IRR & Address Formulas

[JLove]

I am working on a dynamic model and using MS Excel 2003. I want to be able to
set the "return year" in the assumptions and have the CF calculation on the
CFS tab as well as the IRR and NPV calculations on a Ratios tab automatically
adjust. I have worked out how to get the CFs to appear only if within the set
return period, and have tried to get the IRR calculation to automatically
adjust using the following formula:

IRR('CFS'!C55:INDIRECT(ADDRESS(55,('General Assumptions'!G13+3))),.10)

but I get a "Volatile" response from Excel. What does that mean and how can
I fix this formula (preferably without a host of embedded "IF" functions)?

Thanks!
JL

 

[Bernie Deitrick]

JL,

I would try it this way:

=IRR(INDIRECT("'CFS'!C55:"&ADDRESS(55,'General Assumptions'!G13+3)),.10)

 

[JLove]

Bernie-

Thanks so much! That worked!

JL

JL,

I would try it this way:

=IRR(INDIRECT("'CFS'!C55:"&ADDRESS(55,'General Assumptions'!G13+3)),.10)