Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Negative Zero?
Sometimes when I subtract a number from itself, I get a negative zero, rather
than a simple zero. Why is this? |
#2
|
|||
|
|||
probably a small diff somewhere in the 15 digits of the number
-- Don Guillett SalesAid Software "Herbert" wrote in message ... Sometimes when I subtract a number from itself, I get a negative zero, rather than a simple zero. Why is this? |
#3
|
|||
|
|||
It means that your result is less than zero, but not within the precision
you are displaying. For example, if the result is -0.00000000142, and your number format is two decimal places, you will see -0.00. Subtracting a number from itself often results in something other than true zero because computers convert to binary to do computations. Binary conversions are not perfect when extended to 15 decimal places. -- Regards, Fred Please reply to newsgroup, not e-mail "Herbert" wrote in message ... Sometimes when I subtract a number from itself, I get a negative zero, rather than a simple zero. Why is this? |
#4
|
|||
|
|||
"Fred Smith" wrote: It means that your result is less than zero, but not within the precision you are displaying. For example, if the result is -0.00000000142, and your number format is two decimal places, you will see -0.00. Subtracting a number from itself often results in something other than true zero because computers convert to binary to do computations. Binary conversions are not perfect when extended to 15 decimal places. -- Regards, Fred Please reply to newsgroup, not e-mail "Herbert" wrote in message ... Sometimes when I subtract a number from itself, I get a negative zero, rather than a simple zero. Why is this? Fred: Thanks so much for your answer. It very well addresses my problem, and I am grateful. Best regards, Herbert |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating growth with negative numbers | Excel Worksheet Functions | |||
Negative times | Excel Discussion (Misc queries) | |||
How can I change positive numbers to negative, i.e. change 50 to - | Excel Discussion (Misc queries) | |||
can the negative numbers in an IF statement be in a diff color th. | Excel Worksheet Functions | |||
How do I replace a negative number at the end of a formula with a. | Excel Discussion (Misc queries) |