Division Formula in Excel for Multiple Cells (5 Suitable Examples)

If you are searching for some special tricks to use division formula in Excel for multiple cells then you have landed in the right place. There are some ways to use the division formula in Excel for multiple cells. This article will show you each and every step with proper illustrations so, you can easily apply them for your purpose. Let’s get into the central part of the article.


Download Practice Workbook

You can download the practice workbook from here:


What Is Division Formula in Excel?

Actually, Excel does not have any DIVIDE function to perform the Division Operation.

Instead, you have to use the Forward Slash Operator (/) to divide two numbers or cells in Excel. For Example:

  • 25/5 = 5
  • A1/B1 = 5, where cell A1 and cell B1 hold numbers 50 and 10 respectively.
  • A1/10 = 5, where cell A1 holds the number 50.

Basic division formula


Division of Multiple Cells at a Time in Excel

You can use Excel’s division symbol to divide multiple cells in Excel.

For example,

B5/C5/D5 = 5, where B5 = 150, C5 = 3 and D5 = 10

Division of Multiple Cells at a Time in Excel


How Does This Formula Work:

In an Excel formula, division and multiplication have the same order of calculation but with left-to-right associativity. Read this article to know more: Order & Precedence of Operations in Excel.

  • So, at first, B5/C5 will be calculated = 150/3 = 50
  • Then the result of B5/C5 (50) will be divided by D5 = 50/10 = 5

Now check out this image.

Division Formula in Excel for Multiple Cells

You see that formula =A2/(B2/C2) has returned a value of 500. Why?

Because, according to calculation order, the expression inside a parenthesis will be evaluated first.

  • So, (B2/C2) will be evaluated at first = 3/10 = 0.3333
  • Next A2 will be divided by the result of B2/C2 (0.3333) = 150/0.3333 = 500

Hope this is clear to you.


Divide Two or More Numbers Using Forward Slash (/):

Dividing two or more numbers using Excel’s division symbol is the same as dividing two or more cells. See the image below.

Important Notes:

Don’t forget to place an equal sign (=) before the formula; otherwise Excel might treat your entry as a date value. For example, if you input the value 11/19, Excel will show your entry as 19-Nov.

Or, if you type 11/50, the cell might show value Nov-50. The cell will hold value 11/1/1950. This time as 50 cannot be a day value, Excel assumes that you’re typing the month and the year.


5 Examples of Division Formula in Excel for Multiple Cells

In this section, I will show you 4 quick and easy methods to use the division formula in Excel for multiple cells on Windows operating system. You will find detailed explanations with clear illustrations of each thing in this article. I have used  Microsoft 365 version here. But you can use any other versions as of your availability. If anything of this article doesn’t work in your version then leave us a comment.

1. Formula to Divide Entire Column Values by a Specific Number in Excel

Suppose you want to divide the values of a column (multiple cells) using a specific number (say 10). Use these steps.

Steps:

  • In the cell C5, insert this formula:
= B5/10

Formula to Divide Entire Column Values by a Specific Number in Excel

  • Now, drag the Fill Handle icon to paste the used formula respectively to the other cells of the column or use CTRL+C and CTRL+V to copy and paste.

Drag fill handle icon

  • And here is the result. On the right side of the image, you are seeing the formulas. I have used to FORMULATEXT function to get the formulas used in column C.


2. Divide Values Using Absolute Cell Reference with Dynamic User Input in a Column

Now, what if you need to divide the above column with the number 50?

Will you edit the formula by changing the number from 10 to 50, and then copy the formula for other cells in the column?

It is not a good idea. Rather we can write this formula newly. Check out the image below. We have written the formula using an absolute cell reference. Follow the steps below for this.

Steps:

  • Insert the value of the Dividend in cell C4.
  • Then, insert the formula into cell C7 to get the result.
=B7/$C$4

Divide Values Using Absolute Cell Reference with Dynamic User Input in a Column

  • Now, drag the fill handle icon to get the column filled with a similar formula. In column D, you will see the formula text which is used in column C.

Output of Dynamically divide numbers with User Input

  • By inserting different values in cell B2, we can divide the column with different numbers.

Check out the following GIF image.

Dynamically divide numbers with User Input


3. Using QUOTIENT Function to Divide Multiple Cells

You can use the QUOTIENT function to get the quotient value in the integer form excluding the remainder. This function returns the integer part of a division without remainder.

To use this function, insert this formula into the cell D5:

=QUOTIENT(B5,C5)

🔎 Formula Explanation:

Syntax of QUOTIENT function is: QUOTIENT(numerator, denominator)

  • Numerator = B5: It is the Dividend which is the number to be divided
  • Denominator = C5: It is the Divisor by which the number will be divided.

Using QUOTIENT Function to Divide Multiple Cells in Excel

output of QUOTIENT Function to Divide in Excel

Read More: How to Divide Without Using a Function in Excel (with Quick Steps)


4. Formula to Divide by 1000

Suppose,  cell  B5  = 10,000 and you want to divide B5 by 1000. You can use these ways:

  • You can directly, divide cell B5 by 1000. For this, use this formula in cell C5:
=B5/1000
  • Also, you can insert the divisor 1000 in a cell and then, make a cell reference of it to divide. In this case, use the formula below when you have inserted the value 1000 in cell G4:
=B5/$G$4
  • In both cases, you will get the same result, in the first case, you can’t change the dividend value all at once but you can do it in 2nd case.

Division Formula to Divide multiple cells by 1000


5. Excel Formula to Add and Divide Simultaneously

If you want to add some numbers and then divide the sum value with another number, this is a little bit tricky. Suppose you want to add two numbers (say they are 50 and 60) and then want to divide the result with another number 11.

Here is the formula: (50 + 60)/11 = 110/11 = 10

How Do You Add then Divide in Excel

If you write the formula in this way: 50 + 60/11, it will result = 50 + 5.45 = 55.45; you will not get the desired result. Because, according to the order of calculations, the division will perform first (with the left to right associativity) and then the addition.

So, you have to place the addition within a parenthesis. Parenthesis has a higher order of calculations than division.

Want to know more about operator precedence and associativity in Excel? Read this article: What is the Order & Precedence of Operations in Excel?

Now, let’s see several formulas to add and then divide in Excel.

Add and Divide by Typing Numbers Within Cell:

Let’s assume 7 randomly chosen numbers that are to be added and then divided by a fractional number, e.g. 1.052632. We will perform these two operations simultaneously using the following formula within a cell.

=(2500+2300+1700+2600+3000+3500+2300)/1.052632

Excel Formula to Add and Divide Simultaneously within a cell

Using Cell Reference and Excel Functions to Add and Then Divide:

Typing numbers in a formula is not really a good idea. It will be better to use Excel functions with cell references to add and divide using a single formula.

Here we will show you 3 exemplary formulas.

Excel Formula to Add and Divide Simultaneously with or without using functions

Formula Using Cell References Only:

=(B5+B6+B7+B8+B9+B10+B11)/D5

Formula Using SUM Function:

=SUM(B5:B11)/D5

Formula Using QUOTIENT Function:

=QUOTIENT(SUM(B5:B11),D5)

Read More: How to Divide with Decimals in Excel (5 Suitable Examples)

Read More: How to Divide a Number by a Percentage in Excel (3 Suitable Examples)


Handling #DIV/0! Error in Excel Division Formula

In mathematics, you cannot divide a number by zero (0). It is not allowed.

So, when you divide a number by zero in Excel, it will show an error. It is #DIV/0! Error.

Handling #DIV/0! Error in Excel

We can handle #DIV/0! Error in Excel using two functions:


1. Handling #DIV/0! Error Using IFERROR Function

First, let’s use the IFERROR function to handle #DIV/0! Error.

Syntax of IFERROR Function:

IFFERROR(value, value_if_error)

See how I have used the IFFERROR function to handle the #DIV/0! Error.

Generic Formula:

=IFERROR(Division_formula, Value_if_error)

Used Formula in the Following Example:

=IFERROR(B3/C3,"Not allowed")

Handling #DIV/0! Error Using IFERROR Function


2. Handling #DIV/0! Error Using IF function

Now, I will use the IF function to handle the #DIV/0! Error.

Syntax of IF Function:

IF(logical_test, [value_if_true], [value_if_false])

Here is the way to use the IF function to handle #DIV/0! Error.

Generic Formula:

=IF(Set condition as denominator equals to zero, Value_if_true, division_formula)

Used Formula in the Following Example:

=IF(C19=0, "Not allowed",B19/C19)

Handling #DIV/0! Error Using IF function

Read More: [Fixed] Division Formula Not Working in Excel (6 Possible Solutions)


Conclusion

In this article, you have found how to use the division formula in Excel for multiple cells. I hope you found this article helpful. You can visit our website ExcelDemy to learn more Excel-related content. Please, drop comments, suggestions, or queries if you have any in the comment section below.

Kawser

Kawser

Hello! Welcome to my Excel blog! It took me some time to be a fan of Excel. But now I am a die-hard fan of MS Excel. I learn new ways of doing things with Excel and share them here. Not only how-to guide on Excel, but you will get also topics on Finance, Statistics, Data Analysis, and BI. Stay tuned! You can checkout my courses at Udemy: https://www.udemy.com/user/exceldemy/

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo