In the cell opposite monthly payment ... (Pv), which is the loan amount in cell B2. Then close the bracket and press Enter; you will see results. There are two other options to use the PMT function.