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