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:

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!