On Dec 19, 6:24 pm, Peter wrote:
If B26 is <25, then the word YES will show up in the cell.

What you wrote previously is effectively:

=if(and(B26<25,G25=50), "YES", "")

Are you trying to write:

=if(or(B26<25,G25=50), "YES", "")


----- previous posting -----

On Dec 20, 12:50 am, Peter wrote:
This has got me really scratching my head.

I have the following formula in a table:

=IF(B26=25,"",IF(G5=G50,"YES",""))

The problem is thatt B26 is less than 25 (8), and so the answer comes
up blank. But if I change the formula to:

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

Then the cell will say, "YES."

What am I doing wrong?