EDUCBA

EDUCBA

MENUMENU
  • Blog
  • All Courses
  • All in One Bundle
  • Login
Home Excel Excel Resources Excel Tips Divide in Excel Formula

Divide in Excel Formula

Madhuri Thakur
Article byMadhuri Thakur

Updated August 16, 2023

Divide Formula in Excel

Introduction to Divide in Excel

In Excel, division is an arithmetic operation commonly used to divide numbers or values of the cell. It is one of the basic mathematical functions essential for solving complex numeric problems.

Unlike addition, which has built-in functions such as the SUM function, no such function is available for division in Excel. To divide numbers or values of a cell in Excel, you need to start with an equal sign (=), followed by the numbers you want to divide, and put a forward slash (/) between the numbers. Businesses often use the divide formula in Excel to calculate and perform various financial and work management tasks. For instance, they might calculate profit margins, monthly budgets, employee wages, expenditure reports, and other important metrics.

Let’s start by understanding how you can perform division in Excel.

Divide the Formula in Excel
The arithmetic operation or formula for division in Excel starts with an equal sign (=) followed by entering the values or cell references you want to divide and a forward slash (/) between them.

Divide Formula

How to Divide Numbers in a Cell in Excel?

To divide numbers in a cell, directly type the numbers within the cell and apply the divide formula. For example, if you want to divide 10 by 5, enter “=10/5″ in a cell and press “Enter“. The division formula “=10/5” will give a result of 2.

How to Divide Numbers in a Cell in Excel

Note: Please start the formula with an equal sign (=) and use the (/) operator between two values in each cell to get the output. For instance, If you only type 10/5 in a cell, Excel will display 05-Oct. Or else Excel will consider the equation as a date.

Example #1

You can download this Divide Formula Excel Template here – Divide Formula Excel Template

How to Divide Numbers Using Cell References?

You can divide the numbers of two cells by specifying the cell references in the divide formula.
For example, we want to divide the Cell A1 value by the Cell B1 value and display the result in Cell C1.

Solution:
Enter the formula “=A1/B1” in Cell C1 and press “Enter“, where the Cell A1 value is the dividend and Cell B2 value is the divisor. The result will be displayed in Cell C1.

Eg1 solution

Example #2

How to Divide a Column of Numbers by a Constant Number?
Suppose you want to divide the value of each cell of a column by a certain number obtained in another cell. You can easily do this task. In the below example, you will learn how to divide the values of column A by the value of Cell B1.

Divide in Excel-Eg2

Solution:
Step 1: Click on Cell C1
Step 2: Enter the formula =” A1/$B$1” and press “Enter“.

Note: The symbol $ in Excel is used for absolute cell references. In the formula =” A1/$B$1″, the value of the divisor is constant as the value of Cell B1. If you place a dollar sign ($) in front of a row, that row is fixed, and if you place a dollar sign ($) in front of a column, that column is fixed.

Eg2 step2-1

Result 2 is displayed in cell C1.

Divide in Excel-Eg2 step2-2

Step 3: Drag the cell with the formula to get the desired output.

Eg2 step 3

Congratulations, you have successfully done this task.

Example #3

How to Divide Columns in Excel?
You can divide column 1 with column 2 by using the division formula. Consider the below table with numbers in columns A and B. Follow the below steps to learn how to divide two columns in Excel.

Divide in Excel-Eg3

Solution:
Step 1: Click on the Cell D3.

Eg3 step1

Step 2: Enter the formula “=B3/C3” in Cell D3, as shown below.

Divide in Excel-Eg3 step 2-1

Result 5 is displayed in Cell D3.

Eg3 step2-2

Step 3: Drag the formula on the corresponding cell to get the following output.

Divide in Excel-Result of Example 1

Example #4

How to Use the Division (/) Operator with Subtraction Operators (-) in Excel?
Under this method, you will learn to use division operators with other arithmetic operators like subtraction to solve complex division problems.

For example, you have the below data of salespersons and their actual sales in 2021 and 2022. You must calculate the sales growth percentage for the respective salesperson in 2022. Here, you must use the division formula, subtraction, and percentage operator.

Eg4

Solution:
Step 1: Click on the Cell D3
Step 2: Enter the formula “=(C3-B3)/B3” in Cell D3

Note: Using this formula, “=(C3-B3)/B3″, you can calculate the sales growth percentage for the respective salesperson.

Eg4 step 2

The output is 9%.

Eg4 Step2-2

Note: The answer to the formula “=(C3-B3)/B3″ is 0.091910466. For converting the decimal value into a percentage, select Cell D3, go to the “Home” tab, and click “Percentage” in the Number section. The result is 9%, as shown in the above image.

Step 3: Drag the cell with the formula downwards to get the desired output

Eg4 step 3

The above result shows the sales growth percentage for the individual salesperson.

Example # 5

We have the sales data for five famous companies (Apple, Tesla, Netflix, Starbucks, and McDonald’s) for 2021 and 2022 and the estimated figures for 2023. We need to calculate the percentage growth rate for each company for 2023 using basic mathematical operators such as division, subtraction, and the percentage operator.

Eg5

Solution:
Step 1: Add the title “% Growth in 2023” to column E, as shown below.

Divide in Excel-Eg5 Step 1

Step 2: Click on Cell E2.
Step 3: Enter the formula “=(D2-C2)/C2″, as shown below.
According to this formula, we will subtract the sales value of 2022 from 2023 and then divide the result by the sales value 2022. The output is the percentage increase in sales from 2022 to 2023.

Eg5 Step 3

Note: In this example, we used the formula’s opening and closing parenthesis, “( )”.

The output is 8%, as shown below.

Eg5 Step 3-2

Note: The formula “=(B2+C2)/D2″ will give a decimal value. Thus, convert this decimal value into %.

Step 4: Drag the cell with the formula to get the result, as shown below.

Eg5 Step 4

The future sales growth in percentage for all five companies in 2023 is now ready.

How to Use the Division Operator (/) with Addition (+)?

Under this method, you will learn to use the division operator with the addition operator (+) with the help of the following examples.

Example #6

Using Nested Parentheses in Division Operator Using Addition (+)
In this example, we will calculate the average of the student’s marks in maths and science by using the division and addition operator.

Divide in Excel-How to Use the Division Operator

The formula for calculating the average marks of students is: “Total Number of Marks Scored / Number of Subjects.
Solution:
Step 1: Add a new column, “Average“, as shown below.

How to Use the Division Operator Step 1

Step 2: Enter the formula “=(C2+E2)/2″ in Cell F2.
The formula states to add the marks of Maths and Science subjects and then divide by the total subject, i.e., 2.

How to Use the Division Operator Step 2

Result 84 is displayed, as shown in the below image.

How to Use the Division Operator Step 2-2

Step 3: Now, drag the cell with the formula to the rest of the cells.

Divide in Excel-How to Use the Division Operator Step 3

The average score of the students in Maths and Science subjects is displayed.

How to Handle #DIV/0! Error Using IF Function?

While executing the division operation on a data set, Excel will display the error of #DIV/0! When the formula tries to divide a number by an empty cell or 0. In the following example, you will learn how to use the IF function, such as the “IFERROR” condition, to prevent and resolve the #DIV/0! Error.

Suppose you have the below table of dividends and divisors. You have applied the division formula to this data, and Excel has shown error #DIV/0! in Cell C3 and Cell C5 because Cell B3 and Cell B5 have no value. Now, you want to overcome this problem.

How to Handle IF Function Given

Solution:
Step 1: Click Cell G2 of the Result column.
Step 2: Enter the IFERROR formula “=IFERROR(E2/F2,”)” as shown below and press “Enter“.

Note: The Formula “=IFERROR(E2/F2,”)” indicates that divide the value of Cell E2 by Cell F2, and if there is an empty cell or 0 value, then leave the cell blank in the result column to avoid displaying of the #DIV/0! Error.

How to Handle IF Function Step 2-1

Output 4 is displayed.

How to Handle IF Function step2-2

Step 3: Drag the cell with the formula as shown below.

Divide in Excel-How to Handle IF Function Step 3

The result is displayed above, and Cell G3 and Cell G5 are blank instead of #DIV/0! Error.

Things to Remember while Using the Divide Function in Excel

  • Put an equal sign (=) in the cell before using the divide formula.
  • While selecting the data for calculation, do not select the row or column headers.
  • If there is an empty cell or 0 value in the Cell, then Excel will throw an #DIV/0!
  • You should properly use the opening and closing parenthesis in the division formula. For example, formulas like “=10/4-2” will give 0.5 output, and “=10/(4-2)” will give 5 output. Always remember, the “PEDMAS” is the order of calculations in Excel.
  • If you want to display only the integer value of a division operation, use the QUOTIENT function of Excel.

Frequently Asked Questions (FAQS)

Q1. What is the symbol for the divide in Excel?
Answer: The symbol or arithmetic operator used to represent divide or division in Microsoft Excel is “/“, a forward slash. The Excel division formula is “=x/y,” where x is the dividend and y is the divisor.

Q2. How to divide in Excel?
Answer: There are various methods to divide in Excel. You can directly type the numbers in a cell or divide two (or more) numbers by referring to a cell or constant number. As seen in the image below, you must use an equal sign (=) before the division formula and a forward slash (/) between the numbers or cells you want to divide.

Q2-1Q2-2

Q3. What is the other method for division in Excel?
Answer: The alternate method for dividing numbers is using the “QUOTIENT” formula. When you want to display only the integer part of a division, use the formula “QUOTIENT(numerator, denominator)”. If a division equation has a remainder value, the QUOTIENT function will only return the integer value as an output. For example,” =3/2” returns 1.5 whereas “=QUOTIENT(3,2)” returns 1, where 1.5 is the remainder, and 1 is the integer/quotient.

Divide in Excel-Question 3

Recommended Articles

This article has been a guide to Dividing in Excel. Here we discuss the Divide Formula in Excel and How to use Divide Formula in various scenarios using practical examples. Furthermore, you can read our other suggested articles. You also get a downloadable Excel template for your reference.

  1. Divide Cell in Excel
  2. Formatting Text in Excel
  3. Statistics in Excel
  4. Carriage Return in Excel
MICROSOFT POWER BI Course Bundle - 8 Courses in 1
34+ Hours of HD Videos
8 Courses
Verifiable Certificate of Completion
Lifetime Access
4.5
MS Excel & VBA for Data Science Course Bundle - 24 Courses in 1 | 10 Mock Tests
87+ Hours of HD Videos
24 Courses
10 Mock Tests & Quizzes
Verifiable Certificate of Completion
Lifetime Access
4.5
All-in-One Financial Analyst Masters Training Program Bundle - 550+ Courses | 300+ Mock Tests | 2000+ Hours | Lifetime |
2000+ Hours of HD Videos
43 Learning Paths
550+ Courses
Verifiable Certificate of Completion
Lifetime Access
4.9
All-in-One Data Science Bundle - 400+ Courses | 550+ Mock Tests | 2000+ Hours | Lifetime |
2000+ Hour of HD Videos
80 Learning Paths
400+ Courses
Verifiable Certificate of Completion
Lifetime Access
4.7
Primary Sidebar
Popular Course in this category
MS Excel Course Bundle - 36 Courses in 1 | 13 Mock Tests
 137+ Hours of HD Videos
36 Courses
13 Mock Tests & Quizzes
  Verifiable Certificate of Completion
  Lifetime Access
4.9
Price

View Course
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2023 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

Download Divide Formula Excel Template

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download Divide Formula Excel Template

EDUCBA

डाउनलोड Divide Formula Excel Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more