using multiple worksheets to do calculations

[trixma]

I am set an assignment for capital expenditure and i need to create a
input, formulas and output in different worksheets. The reason why w
have to use multiple worksheets is we want to be able to change
figure in the input worksheet and in doing so the output workshee
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 th
cells
if i change 40 to 41 then the output worksheet will contain a differen
answer

I want help on transfering the input number (IRR) from the inpu
worksheet to the formula worksheet, i also want the formula to no
display the answer, but display the answer in the output worksheet.
am having a little trouble working out how this can be done

 

[Paul Sheppard]

Trixma

On the shhet 1 put your value for IRR eg if this is in cell a3, then o
sheet 2 in cell a3 put your formula, then click Tools > Options
Calculation Tab and check the Formula box in Window Options - this wil
make the formula display, on sheet 3 in cell a3 type = and click on cel
a3 in sheet 2, this will display the result of the formula on sheet 3

Pau

 

[trixma]

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

 

[Rob]

It's in the View tab trixma

Rob