Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |