IRR & Address Formulas

J

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
 
B

Bernie Deitrick

JL,

I would try it this way:

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

JLove

Bernie-

Thanks so much! That worked!

JL

Bernie Deitrick said:
JL,

I would try it this way:

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top