View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Notbefore10 Notbefore10 is offline
external usenet poster
 
Posts: 8
Default What is wrong with this formula?

I get the opposite effect when I apply this formula...

=IF(D75=D76,"Balanced","Error")

The answer is "Error", even though the amount is exactly the same in D75
and D76.

If I reverse it I still get the wrong answer...

=IF(D75<D76,"Error","Balanced"

The answer is "Balanced"

I must be missing some very basic syntax knowledge. The cells D75 and
E76 are definitely the same number format.

Thanks for your help.