Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |