Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am trying to take a wages annual figure and increase it by 2.5% but then
make the end figure be divisible by 3. e.g. £15441 (the formula I used was C5 + ($D$4*C5) to pick up the initial figure and find out 2.5 % then add it to the first figure. Now I need to make that final figure £15788.4225 change to read £15789 (because that figure can then divided by 3) Is this possible and if so how -- Thank you for reading my post. Hopefully you can answer my querie |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to sum of two max figures out of five and four figures | Excel Worksheet Functions | |||
add figures to existing figures in excel | Excel Worksheet Functions | |||
How do I add to figures already in a cell? | Excel Worksheet Functions | |||
Changing positive figures to minus figures | Excel Worksheet Functions | |||
How do I make a group of data (not figures) which could be collaps | Excel Worksheet Functions |