Ask Your Question
0

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

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

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
0

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

oweng gravatar image

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

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

Stats

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

Seen: 624 times

Last updated: Nov 10 '13