# How to Divide a Number by a Percentage in Excel (3 Examples)

### Method 1 – Divide a Value by a Percentage in Excel

The Generic Formula:

Actual Price = Total Discount / Discount

Steps:

• Select the cell you want to store the value in.

• Enter the following formula in the cell:

`=C5/D5`

Here, values from cell C5 are dividends, and the percentage number from cell D5 is the divisor.

• Press Enter to get the division result.

• Select the cell again.
• Click and drag the Fill Handle icon to the end of the column to get the values for the rest.

Read More: How to Divide with Decimals in Excel

### Method 2 – Divide a Number with a Specific Percentage in Excel

Steps:

• Select the cell you want to store the division result in.

• Enter the following formula in the cell:

`=C5/4%`

• Press Enter to get the division result.

• To get the rest of the numbers, select the cell again.
• Click and drag the Fill handle Icon to the end of the column. This will apply the same formula to the rest of the cells.

### Method 3 – Divide a Number by a Percentage Using a Cell Reference in Excel

The Generic Formula:

Steps:

• Select the cell you want to store the value in.

• Enter the following formula in the cell:

`=C5/\$D\$11`

Cell D11 is the reference cell here. Use absolute reference so the value doesn’t change for other cells.

• Press Enter to get the number divided by the percentage.

• To find out the rest of the value, select the cell again.
• Click and drag the Fill Handle icon to the end of the column to replicate the formula for the rest of the cells.

## Related Articles

<< Go Back to Divide in Excel

Get FREE Advanced Excel Exercises with Solutions!
Abrar-ur-Rahman Niloy

Abrar-ur-Rahman Niloy, holding a B.Sc. in Naval Architecture and Marine Engineering, has contributed to Exceldemy for nearly 1.5 years. As a leader in Excel, VBA, and Content Development teams, he authored 114+ articles and assisted the Exceldemy forum. Presently, as a project writer, he prioritizes stepping out of his comfort zone, aiming for constant technical improvement. Niloy's interests encompass Excel & VBA, Pivot Table, Power Query, Python, Data Analysis, and Machine Learning libraries, showcasing his commitment to diverse... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF