Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Nested if
I have put together an if statement:
=IF(AND(U8="08",M8/AB8<$O$5),"Problem",IF(AND(B8="Base",M8/AB8<$O$4), "Problem",IF(AND(B8="RDC",M8/AB8<$O$4),"Problem",IF(AND(B8="Branch",M8/AB8<$O $3),"Problem","OK")))) the statement works but not as intended. The only issue is that I want the first condition as sort of an overall condition, that if met, none of the other conditions need to be cycled through. If not met, then cycle through the other functions. The logic is to look at the value in U8 and if it equals "08" and it is less than 31 (m8/ab8), display "Problem". If not equal to "08", then apply the other IF(And functions, that look at conditions in a different column. The issue is that I have not figured a way keep it from cycling through the other conditions. I've tried some "OR" conditions but I can't get it to work. Any suggestions would be appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Limited IF Nested Level functions. | Excel Discussion (Misc queries) | |||
Nested IF statements | Excel Worksheet Functions | |||
how can I exceed the nested if fuction limit | Excel Discussion (Misc queries) | |||
€śUse of more then 7 nested if statement€ť | Excel Worksheet Functions | |||
nested ifs | Setting up and Configuration of Excel |