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.
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.
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.
=504.84/21
- Finally, click ENTER to get the result.
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.
=C5/D5
- Hence, drag down the Fill handle to fill the column.
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.
=C5/$C$14
- Pull the Fill handle down to fill.
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;
{=C5:C12/D5:D12}
- 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.
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;
=QUOTIENT(C5,D5)
- Then dragging down the Fill handle you will get the result.
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.
- Second, select the constant number from the cell C14;
- Now, press CTRL+C to copy which will be divided with other numbers.
- Hence, choosing cells D5:D12, visit the Paste Special option from the Home tab.
- From the Paste Special dialog box, checkmark the Divide option and click OK.
- As a result, you will get the division result in your hands. It’s that simple.
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;
=C5/D5
- Fill all the cells by dragging the Fill handle.
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.
- Now, if we use the below formula in cell E5;
=C5/D5
- Thereafter, drag down the Fill handle and we will get the #DIV/0! Error for those 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;
=IFERROR(C5/D5,"Nil")
- Finish by dragging down the Fill handle.
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.
Conclusion
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
Get FREE Advanced Excel Exercises with Solutions!