XIRR non continguous

  • Thread starter Thread starter Tomek
  • Start date Start date
T

Tomek

Is there a way to refer to nonadjacent cells as an argument in XIRR formula?
 
Tomek,

Have you tried putting the ranges in brackets, e.g.

(A1:A10, B3:F3)

as your values

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
You must log in or register to reply here.

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

Similar Threads

XIRR range question 24
XIRR Help 0
XIRR - Function Missing 1
XIRR & non-Contiguous Values? 10
XIRR non contiguous references 2
XIRR and Non Contiguous Cells 2
XIRR and negative IRRs 1
How to write XIRR formula on excel using different Year basis than 365. 5

Back
Top