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?

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

Kelly P wrote:

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?

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

"Kelly P" <Kelly wrote in message
...
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?

Correction 1.027 should be 1.037

Tyro

"Tyro" wrote in message
...
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

"Kelly P" <Kelly wrote in message
...
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?

The problem is within the rounding. Thanks for your help.

"Bob I" wrote:

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

Kelly P wrote:

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?

You're welcome, have a great day!

Kelly P wrote:
The problem is within the rounding. Thanks for your help.

"Bob I" wrote:


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

Kelly P wrote:


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?