How to use excel proportion function

How to use the excel proportion function: first open the table and enter the number; then enter the formula [=B2/B11] in cell C2 under the proportion column and press Enter; finally choose to set the cell format, and Just select the value type as percentage.

The operating environment of this article: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.

How to use the excel proportion function:

1. Open an excel table:

2. Enter the number you need to calculate the proportion. 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 the total:

4. Press Enter to see the current proportion, but it is displayed as a decimal:

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 to see each cell. Percentage of projects:

##Related learning recommendations:

excel tutorial

The above is the detailed content of How to use excel proportion function. For more information, please follow other related articles on the PHP Chinese website!