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

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

Im using Microsoft XP and i went to tool > Options > Calculation Tab but i cant see where to check the formula box.

It's in the View tab trixma

Rob

"trixma" <trixma.1tbiqc_1123290304.1681@excelforum-nospam.com> wrote in
message news:trixma.1tbiqc_1123290304.1681@excelforum-nospam.com...
>
> 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
>