IRR - #NUM error

B

bluesband

I'm using the IRR function for a string of 36 monthly cash flows. In some instances the formula works great and in others I get a #NUM response. I've also tried condensing my 36 monthly cash flows to 12 quarterly cash flows but end up with the same result. Although part of a larger function, the formula I use is as follows: IRR(1+F124)^12-1.

I've heard that sometimes Excel gets confused when there are two possible IRR's for a given set of cash flows. I do not know if that is the case here or not.

Any suggestions for fixing this problem?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IRR function in Excel 2010 returns #NUM! error for an investment withall negative cash flows 9
XIRR vs. IRR Function 11
IRR showed #NUM! 16
IRR - #NUM error 1
Rate vs. IRR 1
Working with arrays as arguments 6
IRR Trouble 1
Unexplainable XIRR #NUM! Error 3

Top