What I want is if B26 is greater than or equal to 25 then nothing
appears in the cell. Then if G5 is greater than or equal to G50, then
I want the word YES to appear in the cell.

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

Isn't <= how you write "less than or equal to?"


On Wed, 19 Dec 2007 20:01:29 -0800 (PST), joeu2004
wrote:

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.