I am trying to create an IRR function with a dynamic range, such that the range of values to be included in the IRR calculation will adjust automatically depending on the my model. I am trying to work with the following function, but continue to get an error. The following is the relevant information:
Cell AI26 contains a reference to the cell containing the first cash flow I want to include
Cell AI27 contains a reference to the cell containing the last cash flow I want to include
I am trying to use the following formula: =IRR((INDIRECT("AI26"))&":"&INDIRECT("AI27"))
I cannot figure out whether I am missing something in the formula, or if excel just wont recognize this kind of range reference. I appreciate any help you can provide.
Bookmarks