Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I need some help defining a Nested IF Statement.
I need to check for the following conditions: If A1="Yes", then B1, C1, D1, E1 must contain an entry (All 4 cells). If TRUE, then enter "Compliant", otherwise enter "Non Compliant". I need the statement to evaluate each of B1, C1, D1, E1 individually. If B1 has an entry and C1 does not, then "Non Compliant". Is this a clear enough description for some help? Thanks in advance. Frank |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Nested IF | Excel Worksheet Functions | |||
nested if | Excel Discussion (Misc queries) | |||
Nested IF | Excel Worksheet Functions | |||
nested if based on nested if in seperate sheet. how? | Excel Worksheet Functions | |||
Nested If / And / Or ? | Excel Discussion (Misc queries) |