-0.00 FORMULA RETURNING NEGETIVE ZERO

M

MICHELE

why is my total showing a negetive zero. have triple check that the acutal
number doesn't have a hidden value like 5.000000000001 or something like
that. so what else could it be
 
B

Bernard Liengme

This results comes from rounding. Computer must store numbers in binary
(number to base 2)and sometimes there is not an exact match between a
decimal number (number to base 10) and its binary equivalent.
Learn more from these sites:
IEEE 754
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

best wishes
 
Top