View Single Post
  #1   Report Post  
Andrew
 
Posts: n/a
Default Calculation within IF function

I searched b-boards for previous comments, but I didn't see any.

The calculator on my desk says that 5625*0.07 = 393.75.

=IF(5625*0.07-393.75=0,"WIN",5625*0.07-393.75)

Why does Excel think the subtraction in the above agrument is not zero, but
some infinitesimally small number? If typed into Excel, this will not
display WIN.

Any comments?