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