Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|