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