Zero = Zero?
Besure you calculation are set to automatic or hit F9.
Also the logic is =if(A1=B2, True, False) So that if A1 = B2 that is True
0 = 0 is True. You will get False with you logic
"jayklmno" wrote:
I have a formula in a cell that returns a boolean value...
=IF(A1=B2,FALSE,TRUE)
A1=0
B2 =0
I must be going insane, cause it's returning False. Shouldn't zero be
greater than or equal to itself?
|