XIRR non adjacent cells

  • Thread starter Thread starter PJM
  • Start date Start date
P

PJM

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 said:
I have seen the thread on using IRR with non adjacent cells,
but the some range referencing does not work with XIRR
Click to expand...

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!
Click to expand...

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.
 
Back
Top