How to stop calc using un-rounded data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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).
 
Back
Top