How to enter the division percentage formula in excel

The formula for percentage division in Excel is =(numerator/denominator)*100. The specific steps include: Select the numerator and denominator cells. Enter the formula in the result cell. Press Enter.

Excel division percentage formula input method:

In Excel, it is very simple to use the division percentage formula to calculate percentages. The following are the specific steps:

Step 1: Select two cells

• Select the two cells that need to be divided, one as the numerator (dividend) , the other as the denominator (divisor).

Step 2: Enter the formula

• In the cell where you want to display the result, enter the following formula:

<code>=(分子/分母)*100</code>

For example, to calculate the value of cell A1 divided by the value of cell B1 and display the result as a percentage, enter in cell C1:

<code>=(A1/B1)*100</code>

Step 3: Press the Enter key

• Press the Enter key to complete the formula input.

Formula analysis:

• numerator/denominator: Calculate the value of the numerator divided by the denominator.
• *100: Multiply the result by 100 to convert to a percentage.

Using this formula, you can easily calculate the percentage between any two values ​​and display the results directly as a percentage.

The above is the detailed content of How to enter the division percentage formula in excel. For more information, please follow other related articles on the PHP Chinese website!