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 is short for Payment. On the Excel screen, this function can be found using the command fx and under the category ‘Financial’. Here’s an example of how PMT can be used.

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.

Basic Formulas At their most basic, Excel formulas can perform basic math functions and display a solution. For example, the formula "=2+2" will display "4" in the cell.

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

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

3. Select a function from a group (Formulas tab) Narrow your search a bit and choose a formula subset for Financial, Logical, or Date/Time, for example. =TODAY () Inserts today’s date.