Thread: Nested if
View Single Post
  #1   Report Post  
bjd via OfficeKB.com
 
Posts: n/a
Default 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.