IRR with cells not in sequence
 

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?

IRR with cells not in sequence
 

On Apr 14, 5:31 pm, Gordon Bowman-Jones <Gordon Bowman-
wrote:
I've tried IRR(A14:A26+Sheet1!G11) and IRR(A14:A26,Sheet1!G11)
but neither seem to work. What am I missing?

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


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

On Apr 14, 5:31*pm, Gordon Bowman-Jones <Gordon Bowman-
wrote:
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?