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
--
Thank you
Annie

Apologies to JE McGimpsey.

So embarassed at having got your name wrong on my first post to this forum.
Especially as the reason I noticed it was wrong was that you seem to provide
many of the answers here

Sorry again ;-) red
--
Thank you
Annie


"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
--
Thank you
Annie

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

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

Perhaps you could use the Round function in your calculations to round the
numbers to 2 decimals (of course 2 decimals on a number that is already
formatted as % is actually 4 decimals).



"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
--
Thank you
Annie