IRR & Address Formulas
 

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

IRR & Address Formulas
 

JL,

I would try it this way:

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

--
HTH,
Bernie
MS Excel MVP


"JLove" wrote in message
...
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

IRR & Address Formulas
 

Bernie-

Thanks so much! That worked!

JL

"Bernie Deitrick" wrote:

JL,

I would try it this way:

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

--
HTH,
Bernie
MS Excel MVP


"JLove" wrote in message
...
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