Autosum Calculating Wrong

K

Kelly P

On my spreadsheet I have cells that reference calculated totals on other
worksheets, at the bottom of the column I have it auto summing the column.
It's not adding correctly, it's currently 2 cents off from what it should be.
Any ideas on how to get it to add it correctly?
 
B

Bob I

Check the actual numbers in each that are being summed, NOT the rounded
ones you are viewing in the sheet.
 
T

Tyro

This is common in Excel. If for example in A1 you have 1.045 and in A2 you
have 1.037 and you sum the numbers in A3 and you're displaying 2 places of
decimal, you will see in A1: 1.05, B1: 1.04 and A3: 2.08. It appears that
A3 is wrong and should be 2.09. Show 3 places of decimal and you'll see the
underlying numbers 1.045, 1.027 and 2.082. You have to take care of this
rounding problem yourself. Excel is computing correctly.

Tyro
 
T

Tyro

Correction 1.027 should be 1.037

Tyro

Tyro said:
This is common in Excel. If for example in A1 you have 1.045 and in A2 you
have 1.037 and you sum the numbers in A3 and you're displaying 2 places of
decimal, you will see in A1: 1.05, B1: 1.04 and A3: 2.08. It appears that
A3 is wrong and should be 2.09. Show 3 places of decimal and you'll see
the underlying numbers 1.045, 1.027 and 2.082. You have to take care of
this rounding problem yourself. Excel is computing correctly.

Tyro
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cumulative formula for word table 0
An odd problem with SUM(A:B) and AutoSum 2
autosum 1
autosum 3
autosum addition error 3
Autonumber field in Excel that behaves the same as Access 0
Using Autosum 4
LISTNUM + Mail Merge + INCLUDETEXT : Referencing Paragraph # Can't get to work 0

Top