PS....

On Dec 19, 4:50 pm, Peter wrote:
if I change the formula to:
=IF(B26<=25,"",IF(G5=G50,"YES",""))

Then the cell will say, "YES." What am I doing wrong?

If that is what you want, then perhaps you made only two mistakes in
your second effort. Perhaps you wanted the following:

=if(B26<25, "YES", if(G5=G50, "YES", ""))

Note: "<25", not "<=25".

Generally, that is equivalent to the IF(OR(...),...) formula that I
suggested. Arguably, one advantage of your second formulation is that
it will return "YES" if B26 is less than 25, even if G5 contains an
error.

I would prefer to avoid any hypothetical errors in G5. But to each
his own.