Thread: Zero = Zero?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Nils Titley Nils Titley is offline
external usenet poster
 
Posts: 84
Default 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?