How to Divide in Excel with the Division Formula

There are numerous exciting ways to divide numbers and cells in Excel.

Key Takeaways

• Use the Slash Symbol ( / ) – In Excel, the division operator is the forward slash (e.g., =A1/B1).

• Divide Numbers Directly – You can input a simple formula like =100/5 to get the result instantly.

• Avoid Division by Zero Errors – Excel shows #DIV/0! if you attempt to divide by zero or a blank cell.

• Combine with Other Functions – Division formulas can be used inside functions like IF, AVERAGE, and ROUND.

• Reference Cells Dynamically – Using cell references instead of hardcoded numbers makes your formulas reusable and flexible.

Using Division Formula/Operator

The most common way to divide in Excel is to use the Division operator i.e. the forward-slash symbol (/).

What does it do?

Divides two numbers

Formula breakdown:

=number1 / number2

What it means:

=the number being divided / the number you are dividing by

---

In Excel, you can divide two numbers very easily using the Division formula!

The Division Formula is done through the use of the division operator which is depicted by a forward slash:  /

I will show you in the steps below how you can divide numbers in Excel.

This is the table of values that we want to perform division on:

STEP 1: We need to enter the number we want to divide:

=C9

 

STEP 2: Enter the division operator /

=C9 /

 

STEP 3: Enter the number we are dividing by:

=C9 / D9

 

Apply the same formula to the rest of the cells by dragging the lower right corner downwards.

You now have all of the division results!

 

Divide by a Constant Number

In the example below, you have the total sales achieved each month by a company. You want to convert the sales amount in $ ‘000 i.e. you want to divide each sales amount by 1000.

 

How can you quickly divide the sales amount by a constant value i.e. 1000?

Follow the step-by-step tutorial below to achieve the desired result:

STEP 1: Insert the divisor (i.e. 1000) in cell G6.

STEP 2: Copy the value in cell G6. It will be saved in the clipboard.

STEP 3: Highlight the cells in Column E.

STEP 4: Press Alt + E + S to open the Paste Special dialog box.

STEP 5: Press I to select the Divide option. Press OK.

The values in Column D is divided by 1000.

So, you can easily divide the numbers by a constant value using the paste special option in Excel.

 

Using Quotient Function

The Quotient Function is used to divide two numbers and return only the integer portion of the division. It does not provide the remainder and hence can be used when you want to omit the remainder.

If two numbers divide evenly without any remainder, then the result for both Division Operator (/) and Quotient function will be the same.

 

The Syntax of Quotient Function is:

=QUOTIENT(numerator, denominator)

where;

• Numerator – the dividend, i.e. the number to be divided.
• Denominator – the divisor, i.e. the number to divide by.

Make sure that the arguments mentioned in numerator and denominator are numeric, otherwise the QUOTIENT will return #VALUE! error.

Let’s take an example to see how this function work:

Here, you have the total sales achieved by a company each month and the average sale price per product.

Now, you want to know the number of products sold each month!

This can be done using the Quotient Function to divide total sales by average price per product. As the result of this function will provide you with the integer portion of the division.

STEP 1: Select cell F6 and type = to start the formula.

STEP 2: Type Quotient and open bracket (

STEP 3: Select Cell D6 to insert Total sales as the numerator and then type ,

STEP 4: Select Cell E6 to insert Average price per Product as a denominator and then enter close bracket ).

STEP 5: Press Enter.

This will provide you with only the integer portion of the division formula in Excel.

 

#DIV/0! Error in Excel Division Formula

Excel shows a #DIV/0! error when you try to divide a number by 0 or with a blank cell.

If you try a formula like =5/0, it will produce an error.

Look at the example below, when you tried to divide 6441 by 0 Excel has provided you with an #DIV/0! error.

You can easily replace this error with a custom text that you want using an IFERROR function.

IFERROR function returns a value you specify if a formula evaluates to an error; otherwise, it returns the result of the formula.

The syntax of IFERROR is =IFERROR(value,value_if_error)

• value – It is any value or cell reference or an expression.
• value_if_error – The text/value you want to display if the first argument returns an error.

Let’s use this function in our example, to replace the error with a blank.

You can use the formula =IFERROR(B7/C7,””)

The #DIV/0! error has been replaced!!

Frequently Asked Questions

What is the formula for division in Excel?
Use =A1/B1 where A1 is the numerator and B1 is the denominator.

What does it mean when I see #DIV/0!?
This error appears when a formula attempts to divide by zero or a blank cell.

Can I divide multiple numbers in one formula?
Yes, for example, =A1/B1/C1 divides A1 by B1, and then the result by C1.

Is there a way to prevent division errors in Excel?
Yes, use an IF formula like =IF(B1=0,"",A1/B1) to avoid dividing by zero.

Can I use division inside a more complex formula?
Absolutely. Division can be part of nested or combined formulas for advanced calculations.

Conclusion

In this article, you have been provided with a detailed guide on how to divide in Excel using the division operator and quotient function.