Reply to comment
(Number rate, Number nskip, Number amt)
Calculates the Present Value of a future payment. Rate is the discount rate for one time period. Nskip is the number of time periods before the payment occurs. Amt is the amount of the payment.
PV(.10, 2, 121) returns 100