Zero = Zero?
On Mon, 7 Apr 2008 14:18:00 -0700, 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?
Just swap places for the FALSE and TRUE parts of you formula.
Or just make it lik this:
=A1=B2
Hope this helps / Lars-Åke
|