Functions can be used in Then cells of If/Then Rules, Action cells of Decision Tables, and Formulas.

Currently, the list of in-line functions are quite small, but will grow along with auto-complete support in the coming weeks.

PMT - Excel Equivalent

Usage: PMT(RATE, NPER, PV)

• Rate - interest rate for loan (expressed in terms of period, so if you're using months, you may have to divide APR by 12)
• Nper - total number of payments for the loan.
• Pv - present value, or the total amount that a series of future payments is worth now; also known as the principal.

PV - Excel Equivalent

Usage: PV(RATE, NPER, PMT)

• Rate - interest rate for loan (expressed in terms of period, so if you're using months, you may have to divide APR by 12)
• Nper - total number of payments for the loan.
• Pmt - payment made each period and cannot change over the life of the annuity. Typically has reverse sign of PV to reflect cash inflows/outflows

NPER - Excel Equivalent

Usage: NPER(RATE, PMT, PV)

• Rate - interest rate for loan (expressed in terms of period, so if you're using months, you may have to divide APR by 12)