If you are looking for how to create a division formula in Excel, then you are in the right place. Excel division is a very common feature that we need to use in almost every calculation while working with Excel. In this article, we’ll try to discuss how to create a division formula in Excel.

**Table of Contents**hide

## Download Practice Workbook

## 3 Ways to Create a Division Formula in Excel

Excel offers various ways to divide multiple numbers or cells. The methods are handy to use. We just need to follow some simple steps in every method.

### 1. Dividing by a Specific Number

We can divide any number by a specific number in Excel easily.

Suppose, we have the following dataset as **Branch Number**, **Sales in a Week**. We need to calculate **Sales Per Day** in **Column D**.

- Firstly, write the formula in the
**D5**cell like this.

`=C5/7`

Here, **C5 **refers to **Sales in a Week** of **Branch 1**. As a week has **7** days that’s why we have divided it by **7**.

- Secondly, press
**ENTER**to get the output as**49.29**. - Thirdly, use the
**Fill Handle**by dragging down the cursor while holding it at the**right-bottom**corner of the**D5**cell.

- Eventually, we’ll get the outputs like this.

**Read More: ****How to Create a Formula in Excel (5 Ways)**

### 2. Using Absolute Cell Reference to Divide Values

In Excel, when we use **Fill Handle** the cell references normally change according to the reference cells in the formula. But if we always need to divide a number by a fixed cell always, we need to use an absolute cell reference.

In the following dataset, we need to calculate **Sales Per Day** in **Column D** and here, the cell reference is **G4**. It has a value of **10**.

So, firstly, write the formula in the **D5 **cell like this.

`=C5/$G$4`

Here, **$G$4** is the absolute cell reference. The **$** sign has made it absolute and it will not change in the case of using **Fill Handle**.

- Secondly, press
**ENTER**. - Thirdly, use the
**Fill Handle**. - Consequently, the output is like this.

**Read More: ****How to Create a Formula in Excel for Multiple Cells (9 Methods)**

**Similar Readings**

**How to Apply Formula to Entire Column Without Dragging in Excel****Create an Excel Formula to Subtract (10 Examples)****How to Create a Formula in Excel for Multiple Sheets (4 Methods)****Create a Formula in Excel That Will Place the Word Yes (7 Ways)****How to Create a Custom Formula in Excel (A Step-by-Step Guideline)**

### 3. Utilizing QUOTIENT Function to Divide Multiple Cells

We can use **the QUOTIENT function** to divide multiple cells. This function includes multiple cells and gives an output of their division.

Suppose, in the following dataset, we have column headers as **Number**, **Divisor**. We need to get the **Output **in **Column D**.

- Firstly, write the formula in the
**D5**cell like this.

`=QUOTIENT(B5,C5)`

- Secondly, press
**ENTER**. - Thirdly, use the
**Fill Handle**. - And all the outputs will be like this.

**Read More: ****How to Create a Formula in Excel without Using a Function (6 Approaches)**

## Excel Division Formula for Percentage

We can divide a number by percentage value and get an output easily. In the following figure, we have the **Total Discount** of products and **Discount (%)** in **Columns C** and **D** respectively. We need to calculate the **Actual Price** in **Column E**.

Firstly, write the formula in the **E5 **cell.

`=C5/D5`

Secondly, press **ENTER **and use the **Fill Handle** to get the output like this.

**Read More: ****How to Create a Formula to Calculate Percentage in Excel**

## How to Handle #DIV/0! Error While Dividing Cells in Excel

Sometimes, while using division, we face **#DIV/0!** error. This error can occur when the divisor is **0**. Because something divided by 0 gives an error as output. In the following figure, **Column D** values are the outputs of **Column B**/ **Column C**. Here, we can see that the **Divisors **in **Column C** are zero. So, the output becomes **#DIV/0!**.

The solution to this can be.

- We need to change the reference cell which contains a non-zero value
- Changing the divisor to a non-zero value
- Putting
**#N/A**in the divisor cells.**#N/A**actually means blank cell.

So, changing the Divisor to a non-zero value gives the output like this.

Additionally, putting **#N/A** in the Divisor doesn’t give a **#DIV/0!** error.

## Conclusion

That’s all about today’s session. And these are the ways to create a division formula in Excel. We strongly believe this article would be highly beneficial for you. Don’t forget to share your thoughts and queries in the comments section and explore our website **ExcelDemy**, a one-stop Excel solution provider.

## Related Articles

**How to Apply a Formula to an Entire Column in Excel****Create a Multiplication Formula in Excel (5 Easy Ways)****How to Create a Subtraction Formula in Excel (7 Quick Ways)****Create a Conditional Formula in Excel (5 Easy Ways)****How to Create a Complex Formula in Excel (with Easy Steps)****Create a Formula with Structured References in Excel****How to Apply Formula to Entire Column Using Excel VBA**