Zero = Zero?
 

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?

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?

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

Zero = Zero?
 

Are either A1 or B1 the results of a calculation? It could that although it
is showing as zero it is not a true zero. Try formatting the cells to show
15 decimal places and see it they remain zero.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"jayklmno" wrote in message
...
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?