Forum Discussion
IRR functions delivers DIV/0! error
Works sometimes, doesnt work at all others, or works across part of the range but not for full range.
What could be the issue? I have switched iterations on, though there is no circularity, just in case.
Excel functionality has been refreshed via MS support
Did you consult the documentation?
Yes, I did indeed. There is no explanation why the same formula applied to the same numbers produces results at one time, but DIV/0! at others. If the range were all <0, the DIV/0! would make sense. But that's not the case.
It works sometimes, doesn't work others. Numbers unchanged.
Sometimes when I change the guess, it works. Then stops later.
The #DIV/0! error with the IRR (Internal Rate of Return) function in Excel can occur due to various reasons, even when using the same formula and data.
Here are some thoughts
Ensure cash flows include at least one positive and one negative value.
Check the guess value and adjust it if needed.
Verify that all cells in the cash flow range contain valid numeric data.
Increase iteration limits for better convergence.
If using non-periodic cash flows, consider XIRR instead of IRR.
Maybe this will help you, if not...just ignore it.
