D
David Jenssen
The following formula in Excel2003/2007 does not give a zero-result, but it
should do so:
=1595.99-1054.9-541.09-0
If i skip the subtraction of zero at the end, everything works fine, but the
result of 1595.99-1054.9-541.09 equals 0 and subtracting 0 from 0 should also
give 0 as the result. The result displayed in Excel in this case is
-1.13687E-13.
Other calculations subtracting 0 at the end give similar results, for example
=1109.26-906.55-202.71 gives 0 as result, but =1109.26-906.55-202.71-0 gives
2.84217E-14 as result, which is close to 0, but not the same as 0, which is
pretty annoying.
My calculations are taken from a spreadsheet where i have a set of invoices
where i have a total for the paid amount and try to check if the paid amount
equals the invoiced amount by subtracting the invoiced amounts from the paid
amount. I expect to have 0 as difference when the invoice is paid, not these
small numbers.
David
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/com...864f628&dg=microsoft.public.excel.crashesgpfs
should do so:
=1595.99-1054.9-541.09-0
If i skip the subtraction of zero at the end, everything works fine, but the
result of 1595.99-1054.9-541.09 equals 0 and subtracting 0 from 0 should also
give 0 as the result. The result displayed in Excel in this case is
-1.13687E-13.
Other calculations subtracting 0 at the end give similar results, for example
=1109.26-906.55-202.71 gives 0 as result, but =1109.26-906.55-202.71-0 gives
2.84217E-14 as result, which is close to 0, but not the same as 0, which is
pretty annoying.
My calculations are taken from a spreadsheet where i have a set of invoices
where i have a total for the paid amount and try to check if the paid amount
equals the invoiced amount by subtracting the invoiced amounts from the paid
amount. I expect to have 0 as difference when the invoice is paid, not these
small numbers.
David
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/com...864f628&dg=microsoft.public.excel.crashesgpfs