Thank you for the link and the answer
--
Thank you
Annie


"JE McGimpsey" wrote:

One way would be to wrap your calculations with ROUND(), e.g.;

=ROUND(<your existing formula,2)

But if you're averaging or otherwise doing division, that won't
necessarily solve all your problems. See

http://www.mcgimpsey.com/excel/pennyoff.html

In article ,
Annie wrote:

Hi everyone,

I've used the percentage increase answer provided by GE Gimpsey to calculate
increase in fees for this year. Only problem was that the cells are all
formatted to 2 decimal places but calc'ed on full figure so that once rounded
soem of the figures were incorrect if you worked out the %age increase the
old fashioned way by calculator (not old enough - or clever enough - for the
old fashioned way to be in my head)

What can I do to make sure that the calculation is carried out to 2 dec
places without altering the orig data.

TIA