Reverse calculations
Look in HELP for Goal Seek
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"ABrock" wrote in message ...
| 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!
|