Forum Discussion
Excel
Hello! I'm having some issues when I try to find =RATE in Excel, i keep getting the code #NUM! I went through the recommended steps to fix this and still got the same code. If there is any other way...
Can you provide an example of input values that result in #NUM! ?
=RATE(5,0,-16000,-24000)
The 3rd and 4th arguments should have opposite signs.
The 3rd argument PV represents either an amount that you borrow (receive), or an amount that you deposit. If the former, it is positive, if the latter, it is negative.
If you borrow, the 4th argument FV is the amount that you still have to pay back at the end; since you pay it is negative.
If you deposit the initial amount, FV is the amount that you'll receive at the end. since you receive it, it is positive.
So you can use either
=RATE(5,0,16000,-24000)
or
=RATE(5,0,-16000,24000)