Hello,

I would like to be able to round the data in the table below to 2dp, this
however, can throw the calculations out for the totals. Is there any way
that I can have the cell display only 2dp, but the calculations be preformed
on the entire figure?

In the example below, the total figure is 1266.128 - if I format cells to
show 2dp, it changes to 1226.13,

I am using Excel 2003.

A2 B2 C2
TV 3% of TV 8.5% of TV A2-B2-C2
437.96 13.139 37.227 387.596
165.04 4.95 14.03 146.06
396.84 11.91 33.73 351.20
385.62 11.57 32.78 341.27
TOTAL
1226.128


Thanks for help

Charlotte