-0.00 FORMULA RETURNING NEGETIVE ZERO
 

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

-0.00 FORMULA RETURNING NEGETIVE ZERO
 

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/default...NoWebContent=1

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"MICHELE" wrote in message
...
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