XIRR non adjacent cells

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!
 
J

JoeU2004

PJM said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top