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 |
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) |