XIRRfunction

[abhi2611]

Hi,

Is there a way to dynamically change the cell reference in the XIRR formulae

Eg: =XIRR(D10:DS10,D4:DS4)

I want D10 and D4 to change dynamically based on a cell value.

Thanks!

 

[NARAYANK991]

Hi ,

Can you not use named ranges , which can be formulated to be dynamic ?

Narayan

 

[abhi2611]

Any chance that could be done using a formula?

 

[NARAYANK991]

Hi ,

Probably it can , but it will make the formula more difficult to understand.

If you can upload a sample workbook with the formula and the ranges , and how exactly you want them to be made dynamic , it will be easy to suggest an appropriate formula.

Narayan

 

[abhi2611]

Hi Nrayan,

Per your request, attached is a sample file. Based on the valuation date, I want the IRR formula to change dynamically.

Thanks.

 

[NARAYANK991]

Hi ,

So given the valuation date of Jul 1 , 2015 , should the range be from D through J ?

Narayan

 

[abhi2611]

No..it should be J through DS...basically the valuation date is should be the first column.

 

[NARAYANK991]

Hi ,

See your file.

Narayan

 

[abhi2611]

Thanks for you help Narayan.