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