Zero >= Zero?

[jayklmno]

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?

 

[Nils Titley]

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

 

[Lars-Åke Aspelin]

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

 

[Sandy Mann]

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk