-0.00 FORMULA RETURNING NEGETIVE ZERO

  • Thread starter Thread starter MICHELE
  • Start date Start date
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
 
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
 
Back
Top