I have seen the thread on using IRR with non adjacent cells, but the some
range referencing does not work with XIRR function. I am using the following
:
IRR(($J$4:$J$4;J5)) this works but
XIRR(($J$4:$J$4;J5);($H$4:$H$5)) returns #VALUE!

Hi,
What is in J5??, try

=XIRR(($J$4:$J$5),(H4:H5),0.01)


"PJM" wrote:

I have seen the thread on using IRR with non adjacent cells, but the some
range referencing does not work with XIRR function. I am using the following
:
IRR(($J$4:$J$4;J5)) this works but
XIRR(($J$4:$J$4;J5);($H$4:$H$5)) returns #VALUE!

"PJM" wrote:
I have seen the thread on using IRR with non adjacent cells,
but the some range referencing does not work with XIRR

That is correct. Nothing you can do about it. It is a limitation of the
XIRR function -- and most Excel functions.


I am using the following
IRR(($J$4:$J$4;J5)) this works but
XIRR(($J$4:$J$4;J5);($H$4:$H$5)) returns #VALUE!

Why not simply:

XIRR($J$4:J5, $H$4:H5)

In other words, you seem to have contiguous ranges.

I am assuming you have know how to use XIRR. I presume that J4:J5 specifies
two cash flows, and H4:H5 specifies the corresponding dates of those cash
flows.

If that assumption is wrong, please most all the details.