| Home |
| Search |
| Today's Posts |
|
|
|
#1
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
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
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
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
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum if statement with a left statement | Excel Discussion (Misc queries) | |||
| Can an If statement answer an If statement? | Excel Discussion (Misc queries) | |||
| appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
| If statement and Isblank statement | Excel Worksheet Functions | |||
| Help please, IF statement/SUMIF statement | Excel Worksheet Functions | |||
Hybrid Mode
