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:
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!