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...
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.