Total amount is off by a few cents
Posted by A.R. on June 19, 2001 9:54 AM
I receive worksheets from different companies. When I calculate the totals it shows the exact amount. But when I copy the company worksheets to our own worksheets the total is off by a few cents. Why is this?
Posted by Mark W. on June 19, 2001 10:23 AM
Rounding
Posted by A.R. on June 19, 2001 11:18 AM
How do I make Excel show exact amount?
How do I avoid the rounding? I need to have the exact total amount.
Posted by Mark W. on June 19, 2001 11:38 AM
Re: How do I make Excel show exact amount?
One way would be to check "Precision as displayed"
on the Calculation tab of the Tools | Options...
menu command. However, beware! Once you check
this option all constants will be rounded to the
precision as its cell formatting. Also, this
change is not reversible.
