Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reverse calculations
Would appreciate any help on how to do this!
I have a spreadsheet with the following info: Name CurrentBase %Increase AmtIncrease NewBase John 20,000 user input 5% auto calcs $1,000 calcs 21,000 Jay 20,000 auto calc 5% user input $1,000 calcs 21,000 I would like to be able to input a % increase which will automatically calc the amount of increase, add it to the base and generate the New base OR input an amount increase which will reversely calculate the % increase and generate the New base. Thanks in advance! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Double sided print (same page on reverse) | Excel Discussion (Misc queries) | |||
complex calculations | Excel Discussion (Misc queries) | |||
Calculations based on PivotTable information | Excel Discussion (Misc queries) | |||
reverse week count calculations | Excel Worksheet Functions | |||
Calculations crossing multiple sheets | Excel Discussion (Misc queries) |