Ask Your Question

Is it possible to use disjoint cells for IRR range? [closed]

asked 2013-11-04 17:35:08 +0100

hernan gravatar image

IRR(range;guess) does not seem to accept a list of non-contiguous cells as first argument. Am I mistkaken, or there is some workaround?

What I'd want to accomplish is basically the same that is asked here for Excel.

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-13 09:02:19.587300

1 Answer

Sort by » oldest newest most voted

answered 2013-11-10 11:30:34 +0100

oweng gravatar image

updated 2013-11-10 11:37:22 +0100

With spreadsheet data there is usually a workaround. While the "range" is an array, and thus contiguous, what is important is that the "range" component (investment amount or subsequent return payments) only contain related data and not extraneous values, which I think is reasonable. Here are two examples, one in contiguous cells and one where the required values have been extracted from a series containing unrelated values e.g., a bank statement:

IRR example

I have used a basic match against a description column to pull out the related ("return") values in the second example. The two rate of return formula are =IRR(C3:C8) and =IRR(E12:E23). Note that bug fdo#40460 indicates that this particular financial function does not always work as expected.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2013-11-04 17:35:08 +0100

Seen: 784 times

Last updated: Nov 10 '13