Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to stop calc using un-rounded data
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to stop calc using un-rounded data
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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to stop calc using un-rounded data
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 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to stop calc using un-rounded data
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 |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to stop calc using un-rounded data
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can you use two running total data items to calc a third data item | Excel Discussion (Misc queries) | |||
retain calc from another cell after data sort | Excel Worksheet Functions | |||
Data entry too slow even with calc set to manual | Excel Discussion (Misc queries) | |||
auto calc on, but have to edit (f2) cells to force re-calc..help! | Excel Worksheet Functions | |||
How can I stop Excel from displaying rounded numbers? Credit car. | Excel Discussion (Misc queries) |