IRR and non-contiguous range

I am looking to calculate an IRR with cash flows that are not in a single column or row. I am wondering if Numbers can handle a non-contiguous range and if so, how?


After experimenting a bit, I expected IRR((a, b:c, d), ) to work but it didn't. Instead, I got an error message that states, "The formula contains a list where a single argument is expected."


I would suspect that dealing with (or not being able to handle) non-contiguous ranges is not an IRR issue but any function looking for range as an argument.


Has anyone needed to do this and has done so successfully?


-DaverDee

MacBook Pro, Mac OS X (10.7.3)

Posted on Jul 5, 2012 7:31 PM

Reply
3 replies

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

IRR and non-contiguous range

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.