Zero >= Zero?

  • Thread starter Thread starter jayklmno
  • Start date Start date
J

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?
 
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
 
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?
Click to expand...

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
 
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
 
Back
Top