2. Select cell B5 with the mouse, enter "=" in the cell, and then click the Insert Function button.
3. The Insert Function dialog box pops up, select PMT function in Select Function, and then click OK.
4. The function parameter dialog box pops up, and enter "B2/ 12" after the first parameter. Here, cell B2 gives the calculation formulas of annual interest rate and monthly interest rate.
5. Select the cell B3 after the second parameter, which indicates the loan term, and the term is in months.
6. Select the cell B 1 after the third parameter "PV", that is, the current total loan amount is "100000". After all the parameters are designed, click OK.
7. Going back to the worksheet, we can see that the monthly repayment amount is calculated. According to this method, users can fill in and use numbers flexibly.
Extended data:
In order to improve the calculation speed, users had better follow the following drawing principles:
1. Drawing steps: set the map sheet → set the unit and precision → establish several layers → set the object style → start drawing.
2. The graph always uses the ratio of 1: 1. In order to change the size of the pattern, different printing scales can be set in the drawing space when printing.
3. When the pattern of a small area is processed, the scale factor value of the pattern can be reduced; On the contrary, when processing the pattern filling of a larger area, the scale factor value of the pattern can be increased.
4. Set different layers, colors and line widths for different types of primitive objects. The color, line type and line width of primitive objects are controlled by layers.
5. When drawing accurately, you can use the grid capture function and set the grid capture interval to an appropriate value.
6, don't draw the picture frame and graphics on the same screen, you should insert the picture frame block by block in the LAYOUT, and then print out the picture.
Baidu encyclopedia-Microsoft Office Excel