If C20 is in the same sheet 'Cash Flows', try with a named range.

--From menu InsertNameDefine
Names in workbook: myRange
Refers to: ='Cash Flows'!$E$9:$AE$9,'Cash Flows'!$C$20

Hit OK

--Try the formula
=IRR(myRange,0.1)


If this post helps click Yes
---------------
Jacob Skaria


"HB" wrote:

Hello

I am trying to calculate the IRR of a series of cashflows stored
sequentially, except that I need to append a final term to the cash flows
within the formula itself.
i.e. In my formula :
=IRR('Cash Flows'!E9:AE9,0.1)
I need to modify the first argument and add a new term from another cell in
my excel sheet. The first argument in the formula above is an array of
numbers, so basically what I am trying to do is dynamically add a new term at
the end of the array.

I tried variations like:
=IRR({'Cash Flows'!E9:AE9}&{C20},0.1) ; where C20 represents the term I want
to append but none of them seem to work.

It is not an option for me to store the number in another excel sheet (i.e.
I cant enter the number in AF9 and then process the formula with E9:AF9)

Would appreciate it if anyone can help me out with this.

Thanks
HB