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

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

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

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