View Single Post
  #2   Report Post  
Gary''s Student
 
Posts: n/a
Default Incorrect Simple Math

This is simply round-off error. The result of the calculation is not exact
and corresponds to the nearest value that can be represented by the IEEE
number format that Excel uses.
--
Gary's Student


"mklalli" wrote:


61.48-61.42=0.0599999999999952

Why?

This happens frequently in various formulas.

66555.54-66081.35=474.189999999988

What is going on? Surely I'm not the only one that has noticed this?


--
mklalli


------------------------------------------------------------------------
mklalli's Profile: http://www.excelforum.com/member.php...o&userid=12973
View this thread: http://www.excelforum.com/showthread...hreadid=483140