formula help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

=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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel functions 0
Baffeling IF statement 7
COMPARING TIMES AND DISPLAYING TEXT USING IF CONDITION 3
I would like a formula that 1
I need to do a calculation based on the values in two cells 2
Multiple logical formula 8
Adding Cells, Get Error. 2
Excel formula / IF function 5

Back
Top