Home |
Search |
Today's Posts |
#1
|
|||
|
|||
using multiple worksheets to do calculations
I am set an assignment for capital expenditure and i need to create an input, formulas and output in different worksheets. The reason why we have to use multiple worksheets is we want to be able to change a figure in the input worksheet and in doing so the output worksheet should change at the result of this. For example say in the input worksheet i have a cell with IRR=40 and in the formulas worksheet i have 1/(0.5 + IRR)^1 in one of the cells if i change 40 to 41 then the output worksheet will contain a different answer I want help on transfering the input number (IRR) from the input worksheet to the formula worksheet, i also want the formula to not display the answer, but display the answer in the output worksheet. I am having a little trouble working out how this can be done. -- trixma ------------------------------------------------------------------------ trixma's Profile: http://www.excelforum.com/member.php...o&userid=25702 View this thread: http://www.excelforum.com/showthread...hreadid=391162 |
#2
|
|||
|
|||
Trixma On the shhet 1 put your value for IRR eg if this is in cell a3, then on sheet 2 in cell a3 put your formula, then click Tools Options Calculation Tab and check the Formula box in Window Options - this will make the formula display, on sheet 3 in cell a3 type = and click on cell a3 in sheet 2, this will display the result of the formula on sheet 3 Paul -- Paul Sheppard ------------------------------------------------------------------------ Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783 View this thread: http://www.excelforum.com/showthread...hreadid=391162 |
#3
|
|||
|
|||
Im using Microsoft XP and i went to tool Options Calculation Tab but i cant see where to check the formula box. -- trixma ------------------------------------------------------------------------ trixma's Profile: http://www.excelforum.com/member.php...o&userid=25702 View this thread: http://www.excelforum.com/showthread...hreadid=391162 |
#4
|
|||
|
|||
It's in the View tab trixma
Rob "trixma" wrote in message ... Im using Microsoft XP and i went to tool Options Calculation Tab but i cant see where to check the formula box. -- trixma ------------------------------------------------------------------------ trixma's Profile: http://www.excelforum.com/member.php...o&userid=25702 View this thread: http://www.excelforum.com/showthread...hreadid=391162 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding multiple worksheets | Excel Worksheet Functions | |||
Calculations crossing multiple sheets | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
fax multiple worksheets | Excel Worksheet Functions | |||
Countif with multiple criteria and multiple worksheets | Excel Worksheet Functions |