How to find proportion in excel

How to find the proportion in excel: First open the table and enter the number to be calculated; then enter the formula [=B2/B11] in cell C2 under the proportion column; finally select to set the cell format and select The value type can be percentage.

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. Open an excel form:

2. Enter the required To calculate the proportion of figures, here are some simulated data:

#3. Enter the formula =B2/B11 in cell C2 under the proportion column. The idea is to divide the quantity by Total:

4. Press Enter to see the current proportion, but it is displayed in decimals:

##5 . Right-click cell C2 and select Format Cell:

6. Select the value type as percentage:

7. The effect after setting:

8. Use the mouse to select cell C2 and drag it down. You can see the percentage of each item:

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!