Can surplus decimals be omitted when adding derived figures?
 

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?

Can surplus decimals be omitted when adding derived figures?
 

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.]
--
David Biddulph

"DBB9" wrote in message
...
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?

Can surplus decimals be omitted when adding derived figures?
 

On Dec 28, 12:20*pm, DBB9 wrote:
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))