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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reverse calculations
I have provided an example at http://www.HelpExcel.com/examples
The name of the spreadsheet is reverse.xls -- http://HelpExcel.com "ABrock" wrote: 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! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reverse calculations
maybe tricky but i'll try
click toolsoptionsCalculation tab check Calculation Automatic, Check Iteration [3]. then on Current base column :B2 = $20,000 %Increase column: C2=D2/B2 : <format in % AmtIncrease column : D2=B2*C2 : <format in $ NewBase column : E2=B2+D2 select C2:E2 <drag downwards you can only do this on one cell entry (C2 or D2) per row...with a Current base entered. regards B2=D2/ -- ***** birds of the same feather flock together.. "ABrock" wrote: 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! |
Reply |
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) |