How to Create a Division Formula in Excel (3 Useful Methods)

Get FREE Advanced Excel Exercises with Solutions!

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.

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 to Create a Division Formula in Excel

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. So, we will divide the entire column C with a specific number.

how to create a division formula in excel

  • 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.

Dividing by a Specific Number

  • 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.

how to create a division formula in excel

Read More: How to Divide Without Using a Function in Excel


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 we can also use an absolute cell reference in the division formula to divide values.
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.

Using Absolute Cell Reference to Divide Values

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

how to create a division formula in excel


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, and Divisor. We need to get the output in column D.

  • Firstly, write the formula in the D5 cell like this.
=QUOTIENT(B5,C5)

Utilizing QUOTIENT Function to Divide Multiple Cells

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

how to create a division formula in excel


Excel Division Formula for Percentage

We can divide a number by a percentage value and get an output easily. In the following figure, we have the total discount of products and discount percentages in columns C and D respectively. We need to calculate the actual price in column E.

Excel Division Formula for Percentage

Firstly, write the formula in the E5 cell.

=C5/D5

how to create a division formula in excel

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


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.

how to create a division formula in excel

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

Read More: [Fixed] Division Formula Not Working in Excel


Download Practice Workbook


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.


Related Articles

What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Shajratul Alam Towhid
Shajratul Alam Towhid

Hello, myself Shajratul Alam Towhid. Basically, I am a Naval Architect who wants to expand knowledge in the field of Microsoft Excel. I wish all of my articles will be beneficial for the readers.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo