Can surplus decimals be omitted when adding derived figures?

[DBB9]

I have a column of calculated figures, displayed to 2 decimals. When Excel
2003 adds this it includes concealed decimals, creating a rounding error in
the total. How can I delete the excess decimals so they do not distort the
calculation?

 

[David Biddulph]

Either use a helper column =ROUND(A2,2) and total those, or
Tools/ Options/ Calculation/ Precision as displayed [but be careful if you
choose this latter option, as you may get unexpected results elsewhere.]

 

[joeu2004]

I have a column of calculated figures, displayed to 2 decimals. When Excel
2003 adds this it includes concealed decimals, creating a rounding error in
the total. How can I delete the excess decimals so they do not distort the
calculation?

If the column of numbers is A1:A100, you could sum them as they appear
with the following formula:

=sumproduct(round(A1:A100,2))