Calculate IRR with a dynamic range?

[Capt. Awesome]

Hi there,
I'm a newb, please take it easy on me. :-)
I have an income stream that could vary between 15 and 60 years which I want to calculate IRR from. My current formula is as follows : =ROUND(IRR(Stream!F3:F362,0),4), this works great for the fixed 360 interval period (months for 30 years). But what if the investment be only for 10 years? I do not want to calc an IRR for 360 months. I have tried using the OFFSET function with F3 as a reference but must be doing something wrong. I made a new cell for 'IRR term' and tried to input the number of cells to be included in the IRR range but it failed. Do I use this number as 'row', 'height, or both in the OFFSET function?
Any help is greatly appreciated!
Capt.

[vlady]

Welcome to the forum.







Mod Note: To other mod's Copy of this thread in New user Basic...