Forum Discussion
#num! Error in IRR formula
pls help me to sort out above #num! Error in IRR FUNCTION
If I3 is less (more negative) than about -87,509, there is no solution.
IRR tries to find the rate for which the NPV of the amounts in B3:I3 is 0, but there is no such rate: the NPV never becomes 0 or positive. In the chart below, I used I3 = -87.510.
The x-axis is the rate, and the y-axis is the NPV. As you can see, the NPV doesn't touch the x-axis.
For I3=-1,57,249 it is much worse:
The NPV doesn't even come near the x-axis.