Sum is not correct after adding calculated fields

[Laryn]

I have probably 60 rows that have percentage calculations to come up with a
dollar figure. When I then take all those numbers and add them to see total
dollars, I have found that the bottom line is not correct. I routine run
another column, manually adding the dollars for each cell as a double check.

How can I make sure my totals are correct without having to manually add
them. How to I make the sum take the end dollar amount and not be looking at
the calculation anymore?

 

[Sheeloo]

In Excel 2003 go to Tools->Options and check the box 'Precision as displayed'

Pl. make sure that you do not have calculations which might be impacted by
losing precision...

 

[Jacob Skaria]

Laryn

The downside of this option (Tools > Options > Calculation > Precision as
displayed) is that it affects the calculations of all cells in the
spreadsheet. That may or may not be what you want.

If this post helps click Yes

 

[Laryn]

Okay, so if this could affect the calculations - is there anything else I can
do?

 

[Gord Dibben]

Have aread here at John McGimpsey's site.

http://www.mcgimpsey.com/excel/pennyoff.html

Bottom line...............

Unfortunately, there's no hard and fast rule for how to deal with this
problem. The key is to be aware that it exists, and to design your workflow
to handle the error in an appropriate way.



Gord Dibben MS Excel MVP