The PMT () function, for example, calculates a loan payment given the number of payments, the interest rate and the principal amount. You use it in a cell formula as the following example illustrates: ...