C crapit May 11, 2009 #1 1 value of a cell minus another similar value of another cell = a negative value with a negative notation power. Is this a bug?
1 value of a cell minus another similar value of another cell = a negative value with a negative notation power. Is this a bug?
B Bernard Liengme May 11, 2009 #2 Maybe the two values are not exactly the same. Could this be IEEE round-off error? Chip's clear explanation http://www.cpearson.com/excel/rounding.htm Floating-point arithmetic may give inaccurate results in Excel http://support.microsoft.com/kb/78113/en-us (Complete) Tutorial to Understand IEEE Floating-Point Errors http://support.microsoft.com/kb/42980 What Every Computer Scientist Should Know About Floating Point http://docs.sun.com/source/806-3568/ncg_goldberg.html http://www.cpearson.com/excel/rounding.htm Visual Basic and Arithmetic Precision http://support.microsoft.com/defaul...port/kb/articles/Q279/7/55.ASP&NoWebContent=1 Others: http://support.microsoft.com/kb/214118 http://docs.sun.com/source/806-3568/ncg_goldberg.html
Maybe the two values are not exactly the same. Could this be IEEE round-off error? Chip's clear explanation http://www.cpearson.com/excel/rounding.htm Floating-point arithmetic may give inaccurate results in Excel http://support.microsoft.com/kb/78113/en-us (Complete) Tutorial to Understand IEEE Floating-Point Errors http://support.microsoft.com/kb/42980 What Every Computer Scientist Should Know About Floating Point http://docs.sun.com/source/806-3568/ncg_goldberg.html http://www.cpearson.com/excel/rounding.htm Visual Basic and Arithmetic Precision http://support.microsoft.com/defaul...port/kb/articles/Q279/7/55.ASP&NoWebContent=1 Others: http://support.microsoft.com/kb/214118 http://docs.sun.com/source/806-3568/ncg_goldberg.html
