| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Tab sequence | Excel Discussion (Misc queries) | |||
| How do I find the minimum NONBLANK value in a sequence of cells? | New Users to Excel | |||
| How to copy cells horizontally to cells out of sequence | Excel Discussion (Misc queries) | |||
| How to sum cells with a certain letters sequence | Excel Worksheet Functions | |||
| the first in a sequence | Excel Discussion (Misc queries) | |||
Linear Mode
