|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 15th, 2008, 09:13 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Statement
I am creating a spreadsheet with several conditional formulas. They all work
except for one. I need the following: IF S4 = YES and T4 = YES then W4 = YES else NO OR IF U4 = YES then W4 = YES else NO I can get this part to work: =IF(AND($S4="YES"|$T4="YES")|"YES"|"NO") But I cannot put the OR in there. Can you help? 
|
|
#2
September 15th, 2008, 09:19 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF Statement
Try this:
=IF(OR(U4="Yes",AND(S4="Yes",T4="Yes")),"Yes","No" ) -- Biff Microsoft Excel MVP "KC_Cheer_Coach" wrote in message ... I am creating a spreadsheet with several conditional formulas. They all work except for one. I need the following: IF S4 = YES and T4 = YES then W4 = YES else NO OR IF U4 = YES then W4 = YES else NO I can get this part to work: =IF(AND($S4="YES"|$T4="YES")|"YES"|"NO") But I cannot put the OR in there. Can you help?
|
|
#3
September 15th, 2008, 09:20 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF Statement
=IF(OR(AND(S4="YES","T4="YES"),U4="YES"),"YES","NO ")
"KC_Cheer_Coach" wrote in message ... I am creating a spreadsheet with several conditional formulas. They all work except for one. I need the following: IF S4 = YES and T4 = YES then W4 = YES else NO OR IF U4 = YES then W4 = YES else NO I can get this part to work: =IF(AND($S4="YES"|$T4="YES")|"YES"|"NO") But I cannot put the OR in there. Can you help?
|
|
#4
September 15th, 2008, 09:36 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF Statement
This worked when I replaced the commas with pipes and took the extra
quotation out from in front of T4. Thank you sooooo much. It was driving me bonkers! "Bob Umlas" wrote: =IF(OR(AND(S4="YES","T4="YES"),U4="YES"),"YES","NO ") "KC_Cheer_Coach" wrote in message ... I am creating a spreadsheet with several conditional formulas. They all work except for one. I need the following: IF S4 = YES and T4 = YES then W4 = YES else NO OR IF U4 = YES then W4 = YES else NO I can get this part to work: =IF(AND($S4="YES"|$T4="YES")|"YES"|"NO") But I cannot put the OR in there. Can you help?
|
|
#5
September 15th, 2008, 10:08 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF Statement
This worked when I replaced the commas with pipes
I've never seen | used as argument separators! -- Biff Microsoft Excel MVP "KC_Cheer_Coach" wrote in message ... This worked when I replaced the commas with pipes and took the extra quotation out from in front of T4. Thank you sooooo much. It was driving me bonkers! "Bob Umlas" wrote: =IF(OR(AND(S4="YES","T4="YES"),U4="YES"),"YES","NO ") "KC_Cheer_Coach" wrote in message ... I am creating a spreadsheet with several conditional formulas. They all work except for one. I need the following: IF S4 = YES and T4 = YES then W4 = YES else NO OR IF U4 = YES then W4 = YES else NO I can get this part to work: =IF(AND($S4="YES"|$T4="YES")|"YES"|"NO") But I cannot put the OR in there. Can you help?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
