I didn't check the whole formula, but the front end that you're concerned
about seems to work as you wish it. The problem you're experiencing may be
because your formula requires "08" (a TEXT value) and you may be trying to
get it to work with a number 8............so it just blows by to the next
section.

Vaya con Dios
Chuck, CABGx3


"bjd via OfficeKB.com" wrote in message
...
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.