Formula Help
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?
|