SumsWhen cells are rounded to 3 decimals

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

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" <[email protected]> wrote in message
news:[email protected]...
> 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