Excel will show the #NUM error if a formula uses a function that iterates, such as IRR or RATE, and cannot find a result. Follow the steps below to change the number of times Excel iterates formulas: ...

Excel offers three functions for calculating the internal rate of return, and I recommend you use all three.