Thread: Zero = Zero?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Lars-Åke Aspelin[_2_] Lars-Åke Aspelin[_2_] is offline
external usenet poster
 
Posts: 913
Default 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