=IF(A1=0,"",IF(B1D1,"NAUR",IF(B1C1,"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 b1d1 first than reading B1c1? Because in some cases b1 will be
always than both c1 and d1

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

If you want "DENIED" returned if B1C1 and B1D1, switch the order of
the comparisons.

In article ,
Frances C wrote:

=IF(A1=0,"",IF(B1D1,"NAUR",IF(B1C1,"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 b1d1 first than reading B1c1? Because in some cases b1 will be
always than both c1 and d1