formula help

F

Frances C

=IF(A1=0,"",IF(B1>D1,"NAUR",IF(B1>C1,"DENIED","")))

This formula has been working fine, but for some unknown reason the formula
was not working corrrectly yesterday. my question is will this formula
always read b1>d1 first than reading B1>c1? Because in some cases b1 will be
always > than both c1 and d1
 
J

JE McGimpsey

Yes, if B1>D1, then "NAUR" will be returned, and the comparison between
B1 & C1 won't be performed.

If you want "DENIED" returned if B1>C1 and B1>D1, switch the order of
the comparisons.
 
Top