Also, note that the present value variables includes a negative sign, without which the formula will return an error. Just as before, you have the option of directly entering variables, such as =RATE(5,,-100000,180000), or by referencing variables, such as =RATE(B3,,-C1,C2)..