Sums
 

Data does not total correctly either across rows or down columns.
Data in cells to be totaled are each based on a different percentage of one
cell.
Cells are rounded to two decimal points.
Sum across rows is incorrect, then sum down the column containing the totals
is also incorrect.
When cells are rounded to 3 decimals, everything is fine, but I need two
decimals.

Using Excel2003

Sums
 

Have you tried Tools, Options, Calculations, Precision as Displayed?


--
raypayette


------------------------------------------------------------------------
raypayette's Profile: http://www.excelforum.com/member.php...o&userid=29569
View this thread: http://www.excelforum.com/showthread...hreadid=565651

Sums
 

Hi madmam

Have a read of this: http://www.mcgimpsey.com/excel/pennyoff.html and see
if that explains what you've got!

Hope this helps.
Andy.

"madmam" wrote in message
...
Data does not total correctly either across rows or down columns.
Data in cells to be totaled are each based on a different percentage of
one
cell.
Cells are rounded to two decimal points.
Sum across rows is incorrect, then sum down the column containing the
totals
is also incorrect.
When cells are rounded to 3 decimals, everything is fine, but I need two
decimals.

Using Excel2003