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