IRR with cells not in sequence

  • Thread starter Gordon Bowman-Jones
  • Start date
G

Gordon Bowman-Jones

I am trying to calculate an IRR with a sequence of positive and negative cash
flows in sequential cells, (e.g. IRR(A14:A26) but at the end of the sequence
I want to add the NPV of the equipment for a future stream of income. I have
calculated this seperately but can't seem to add it to the IRR calculation.

I've tried IRR(A14:A26+Sheet1!G11) and IRR(A14:A26,Sheet1!G11) but neither
seem to work. What am I missing?
 
J

joeu2004

I've tried IRR(A14:A26+Sheet1!G11) and IRR(A14:A26,Sheet1!G11)
but neither seem to work. What am I missing?
Click to expand...

An extra set of parentheses. Try IRR((A14:A26,Sheet1!G11))


----- original posting -----
 

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

IRR function in Excel 2010 returns #NUM! error for an investment withall negative cash flows 7
IRR, with cash flows in non-adjacent cells 6
Working with arrays as arguments 6
IRR the same for very different cash flows 3
IRR function when the cash flows are not in array? 2
NPV IRR MIRR 3
irr of growing perpetuity 10
Array issue 7

Top