I usually encounter this error if the IRR is so low that the IRR is not worth calculating (investment loss). However, I have $2.4 million of investment with $5.9 million of return. I keep getting a #DIV/0 error until I try numerous "Guesses." I can get it to work with a -.10% guess.
I understand that Excel will attempt 20 passes at calculating the IRR, then return an error if it cannot solve for the IRR. Is there a way to get Excel to try more than 20 attempts?
I don't think changing "Iterations" in the Calculation tab will increase the number of attempts Excel will try before giving up on the IRR calculation. Any ideas?
I understand that Excel will attempt 20 passes at calculating the IRR, then return an error if it cannot solve for the IRR. Is there a way to get Excel to try more than 20 attempts?
I don't think changing "Iterations" in the Calculation tab will increase the number of attempts Excel will try before giving up on the IRR calculation. Any ideas?