Step-by-Step 1 – Explore Functions

PMT Function. You can have Excel calculate payments, as well as interest, and principle. Select the cell where you want to display the result of the function. Click the to the right of the AutoSum button on the Standard toolbar. Select More Functions. (You can also click the Insert Function … ................
................