IRR function

Generic selectors
Exact matches only
Search title only
Search in content
Search in all posts
Search in pages
Answers
Questions
Solved2.52K viewsFormulas and Functions
0

Hi,

I’m trying to use this function (irr), but doesn’t work when I use it with a matrix with more than two dimensions (appears "#NUM" in the cell).

So I don´t know if that formula doesn’t work in this cases or I´m doing something wrong.

I attached an example for more explanation.

Thanks.

Selected answer as best

Attachments

IRR.model
0

vishnuyarlagadda,

I think I figured it out using sublist(), first(), last(). See the attached model and the Answer Item formula. It solved for Cash1.

Let me know if this is what you were looking for. It seems to be slightly off of what excel is giving you.

Good Luck.

Rich

Selected answer as best
You are viewing 1 out of 14 answers, click here to view all answers.

Latest Questions