How to calculate the proportion in excel: first enter the calculation data and the proportion calculation formula [=B2/810]; then double-click the green dot in the lower right corner to generate calculation results in batches; then click on the unit Select the cell to format the cell, and select "Percent" in the dialog box that opens; finally, select "2" for the number of decimal places.
The operating environment of this article: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.
How to find the proportion in excel:
1. First, enter the data to be calculated in the cells of the excel table.
2. Then enter the proportion calculation formula in cell C1: =B2/810, which means dividing the "number of undergraduate students" by the total number of students.
#3. Click Enter to generate calculation results. Double-click the green dot in the lower right corner to generate calculation results in batches.
#4. After all calculation results are generated, you can see that decimals are displayed and need to be converted into percentages.
5. Right-click the cell and select Format Cells. In the dialog box that opens, select "Percent" and select "2" for the number of decimal places. Click Sure.
#6. You can change the proportion value to a percentage display.
Related learning recommendations: excel tutorial
The above is the detailed content of How to find proportion in excel. For more information, please follow other related articles on the PHP Chinese website!