How to Divide in Excel (Using Functions and Features)

Get FREE Advanced Excel Exercises with Solutions!

In this Excel tutorial, you will learn in detail about how to divide in Excel including dividing numbers directly, by a constant number, applying the array formula, using the QUOTIENT function, and Paste Special feature.

We used Microsoft 365 to prepare this article. But you can apply the operations in Excel’s previous versions except the QUOTIENT function, which is available from Excel 2007 onwards.

Dividing in Excel is a fundamental operation for computing ratios, proportions, or distributed quantities. Microsoft Excel is a versatile platform for dividing with ease. Inputting a division formula, you can get the proper result with precision.

In the following, you will find an overview of how to divide in Excel.

Overview of dividing in Excel

Download Practice Workbook

How to Divide in Excel?

There are several ways to divide numbers in Excel.

  • Using the division operator (/)
  • Using cell references
  • Applying Array Formula
  • Using the Paste Special feature

1. Can We Divide Numbers Directly?

Yes, you can simply use the slash sign (/), also known as the division operator, to divide numbers directly. This is a fundamental arithmetic operation that allows you to partition one quantity by another. Place it between the numerator and denominatior.

  • Here, we choose a cell E5;
  • Then, write the cell values manually with a slash sign(/) between those numbers to divide directly.
  • Finally, click ENTER to get the result.

Dividing numbers directly using slash sign between numbers

2. What Is the Way to Divide Numbers Using Cell References?

You can use the cell references to divide numbers. This is an excellent feature that will enable you to execute dynamic calculations.

  • Start with choosing a cell E5;
  • Next, write the below formula, and click ENTER.
  • Hence, drag down the Fill handle to fill the column.

Division formula with cell references

3. How to Divide by a Constant Number?

If you want to divide by a constant number then you can use the absolute reference ($) to lock the cell. Dividing column or rows with a constant value from a cell is a fundamental operation in many fields of study and application.

  • Similarly, choose a cell D5, and put the division formula;
  • Here we will divide values with a constant value from cell C14.
  • Pull the Fill handle down to fill.

Dividing multiple numbers from a column by a constant number

4. Can We Use Array Formula to Divide One Column by Another?

Yes, you can use an array formula to divide one column by another. This is a time-saving task where you don’t need to drag down to fill columns. With a single click you will get the division result for all the cells.

  • Simply, selecting cells E5:E12, and write the below formula;
  • Then, press ENTER to apply the array formula.

Note: If you are not using Excel 365 then you must press CTRL+SHIFT+ENTER to apply the array formula.

Applying array formula for dividing one column with another

5. What is the Way to Use the QUOTIENT Function to Divide?

You can apply the QUOTIENT function to divide and round up the division result. This method is of great use to avoid the decimal part from your division output.

  • Start with selecting a cell (E5), and write the below formula;
  • Then dragging down the Fill handle you will get the result.

Formula of QUOTIENT function to divide and round numeric values

6. Can We Use the Paste Special Feature to Divide?

Yes, you can also use the Paste Special feature to divide numbers by a constant value. The paste special feature offers a versatile way to divide values within your spreadsheet.

  • First, we will copy and paste the value to a new column that we want to divide.

Copying and pasting to a new location to apply the paste special feature

  • Second, select the constant number from the cell C14;
  • Now, press CTRL+C to copy which will be divided with other numbers.

Pressing CTRL+C to copy constant number for division operation

  • Hence, choosing cells D5:D12, visit the Paste Special option from the Home tab.

Clicking paste special from the Home tab

  • From the Paste Special dialog box, checkmark the Divide option and click OK.

Selecting divide option from the paste special window

  • As a result, you will get the division result in your hands. It’s that simple.

Final output with dividing numbers using paste special feature

How to Divide by Percentage in Excel?

Sometimes you might need to divide numbers by percentages in Excel. Dividing by a percentage is a common operation for adjusting values based on proportional changes.

Suppose we have a dataset of some products’ Discount Price and Discount Rate. In order to determine the Actual Price you can divide directly using the basic arithmetic formula.

  • In the same fashion, choose a cell E5, and put the below formula;
  • Fill all the cells by dragging the Fill handle.

Final result with dividing numbers with percentages

How to Ignore/Handle Errors While Dividing in Excel?

While dividing you will find a division error (#DIV/0!) when the divisor is zero (0) or the cell reference is blank. Suppose we have some blank cells in our dataset just like the image below.

Sample dataset with blank cells

  • Now, if we use the below formula in cell E5;
  • Thereafter, drag down the Fill handle and we will get the #DIV/0! Error for those blank cells.

Result with division error for blank cells

  • In order to ignore those errors you can apply the IFERROR function to ignore/handle those errors.
  • Similarly, choose a cell E5 and write the following formula;
  • Finish by dragging down the Fill handle.

Formula of IFERROR function to ignore errors while dividing

Which Things to Remember While Dividing in Excel?

  • While working you might get a value error (#VALUE!) when you divide numbers with text values. To convert text values to numbers you can use the VALUE function in Excel.
  • When using the QUOTIENT function in Excel, remember that it returns only the integer portion of a division, ignoring any remainder.
  • Make sure to use the exact formatting in Excel. Inconsistent formatting can cause Excel to misinterpret numbers, especially when dealing with text mixed with numbers.

Frequently Asked Questions

1. Is it possible to divide numbers in Excel with zero in the denominator?

Dividing any number by zero will result in an error in Excel. To ignore errors you can use the IFERROR function in Excel.

2. Can I use cell references from different worksheets in a division formula?

Yes, you can divide cell references from different worksheets by specifying the sheet name along with the cell reference.

3. How can I get the remainder after the division operation in Excel?

You can use the MOD function to get the remainder from a divisional result or any decimal values.


In conclusion, we have learned how to divide in Excel by using the slash sign (/) or with the QUOTIENT function, among others. Just ensure all the cells involved in the division operation include numeric values to avoid errors. Absolute references ($) stay fixed, while relative references adjust when dividing with other cells. For large datasets, try using the Paste Special feature in Excel. Please inform us in the comment section about your experience. We, the Exceldemy team, are always responsive to your queries. Stay tuned and keep learning.

How to Divide in Excel: Knowledge Hub

<< Go Back to How to Calculate in Excel | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Wasim Akram
Wasim Akram

Wasim Akram holds a BSc degree in Industrial and Production Engineering from Ahsanullah University of Science and Technology. Over the past 2 years, he has been actively contributing to the ExcelDemy project, where he has authored more than 150 articles. Now, he is working as an Excel VBA and Content Developer. He likes learning new things about Microsoft Office, especially Excel VBA, Power Query, Data Analysis, and Excel Statistics. He is also very interested in machine learning and... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF