Thread: Formula Help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Peter[_8_] Peter[_8_] is offline
external usenet poster
 
Posts: 27
Default 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?