Excel XP autosum errors

  • Thread starter Thread starter Jim
  • Start date Start date
J

Jim

When adding numbers in a column autosum consistently adds
them incorrectly. The errors range from a penny to
several cents off.

I use these spreadsheets monthly and it is becoming more
annoying because I cannot rely on any accuracy of figures.

Are there any settings I can change to correct this?

Thanks!

Jim
 
This can happen depending on how the numbers are entered. Excel by default
performs math on numbers using the maximum precision of the numbers as they
are entered and computed.This is even if you have the numbers formatted to
show, say, only 2 decimal places.

But if you want to force Excel to use no more precision than what is
actually displayed in the cells, then do this: Tools, Options, Calculation
tab, and select the option "Precision as displayed."

Another option is to use the ROUND function in your formulas, but I think
the above solution is much easier to implement.

MRO
 
Back
Top