How to find proportion in excel

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!