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: ...

=PMT (9.5%/12, 20*12, 5000000) Overall, you can use the PMT function to create budgets, compare loan offers, plan your monthly payments, and create an amortization table.

The PMT function in Excel is a financial function used to calculate a loan's payment based on payments and interest rates. Learn How to use it.

For example, the SUM function is a popular choice for quickly adding numbers. Instead of writing =A1+A2+A3+A4+A5, you can simply use =SUM (A1:A5). Note that these are both formulas, but only the ...

This instructs Excel that there are headers and to show them. See the formula and grouping on the next page that now contain headers. Let’s group the transactions the same as we did in the example ...