Can surplus decimals be omitted when adding derived figures?

  • Thread starter Thread starter DBB9
  • Start date Start date
D

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?
 
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.]
 
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?
Click to expand...

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

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