Excel giving me incorrect total amount
Posted by A.R. on July 20, 2001 8:45 AM
I copy a group of numbers from an invoice sheet and I do the auto sum to verify that the exact total amount matches the invoice sheet. Excel shows the exact total and matches the total in the invoice sheets. But now I copy some numbers and the total amount is off by a dollar and a few cents. When I add these numbers using a calculator the exact total amount is correct. Why is Excel giving me an incorrect exact total amount? Note that I have precision as displayed checked in the Calculation tab in the Options section.
Posted by faster on July 20, 2001 9:17 AM
precision as displayed is just that, it truncates
any decimals that are not displayed. Just an idea.
Posted by Mark W. on July 20, 2001 11:51 AM
> it truncates
No. It rounds.
Posted by Mark W. on July 20, 2001 12:18 PM
Are you using SUM()? Is the amount that you're off
the sum of 1 or more of your pasted values? Use
ISNUMBER() to verify that all pasted numbers were
recognized by Excel as numeric.
Posted by faster on July 25, 2001 12:06 PM
the number displayed is rounded and it truncates
what is not displayed.
*from Excel*
Permanently changes stored values in cells
from full precision (15 digits) to whatever
format, including decimal places, is displayed.
