You also need the amount of the fixed payment entered as a negative value.
See Excel help on "Rate".
--
Jim Cone
Portland, Oregon USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)


"Kevin W"
wrote in message
So present value = future value / (1+discount rate)^n where n is the number
of compounding periods.
If I have PV, FV, and n, I assume I use the RATE formula to get the interest
rate. I keep getting #NUM. Any suggestions?
Thank you