How to Divide Numbers in Excel with 6 Ways

How to Divide in Excel

There is no specific divide function in Excel. However, the / symbol is used to indicate division. There are 6 different formulas that you can use to divide numbers and multiple cells in Microsoft excel.

Excel software helps solve many mathematical calculations. You can use different formulas to get the sum, division, multiplication, quotient, mean, mode, median, and other mathematical calculations. In terms of division, there are many methods you can use to get your result. Not only that, but also the remainder and quotient of divided numbers. I will share 6 of the best methods you can use to divide numbers in Microsoft Excel.


1. Calculated Separately

Step 1: If you only have one equation to calculate, go straight to the cell and type the number you want to divide. The bloggers writing for https://www.chroniclesofdata.com/ would suggest adding the division sign (/) before typing the number you have to divide by. For example, if you want to divide 5 by 2, type ‘5/2' in the cell. Now press enter and you will get your result.

Step 2: Click on the cell and type =1000/5. Click enter; the cell will display 200 as a result.

cell

right arrow symbol

2nd cell

Step 3: If you have multiple numbers you can write them down in different cells and follow the same procedure.


2. Divide the Whole Column by a Fixed Number

Step 1: If you want to divide all the values in column A by a fixed number, do the following:

First, write all the numbers in column A.

column A first cell

column A 2nd cell

Step 2: On Column B, write the division formula. Do this by writing = then select the number, e.g., 100, and it will display its row number, A2. The formula will look like this =A2/2 depending on where your number is.

Column B first cell

Column B 2nd cell

Step 3: Click enter, and the formula will divide the number. You will get 50. Click on the dot at the bottom right of the cell in B2. A small black cross will appear; hold down the left mouse button and drag it down.

Step 4: All the numbers will be divided.

Divide the whole column


3. The Whole Column Calculation

To better organize a table, you can write the dividends in column A, divisors in column B, and output in column C.

Step 1: First, enter the rows of data, with column A as the dividend and column B as the divisor.

Step 2: Input the division formula in column C2: = A2/B2. To do this, write = then highlight A2 first, then B2.  Alternatively, write =A2/B2 and click Enter.

division formula first column

division formula 2nd column

Step 3: Click on the dot at the end of cell C2. A small black cross will appear, hold down the left mouse, and drag down. It will provide the answers for the other numbers.

division formula result

 Step 4: According to the rules of mathematics, 0 cannot be used as a divisor, so when there is a 0 in column B, or when there is no number, “#DIV/0!” will be displayed.

DIV rules

For this error indication, Use this function: =IFERROR(G3/H3, “), which sets the divisor to zero and does not display the result.

IFERROR function


4.  Quotient (Integer Function)

This method uses the formula =QUOTIENT(dividend, divisor). This method leaves you with the quotient while discarding the remainder.

Step 1: Write your numbers in the first two columns, dividend, and divisor.

Step 2: In the third column, write the formula =QUOTIENT(dividend, divisor).

QUOTIENT first column

QUOTIENT 2nd column

Step 3: Click enter, and in the results part, it will show the number of times 13 can be divided by 5. For example, when 13 is divided by 5, the quotient is 2, the remainder is 3.

Step 4: The formula discards the remainder and keeps the quotient.

Step 5: You can do the same for multiple numbers. Just click on cell C2, and on the bottom right, a cross will appear, hold the left mouse button down and drag it down.

QUOTIENT result column

  • Note: If either of the arguments is non-numeric, the quotient formula will return the #VALUE!error. Also, if the denominator is 0, the QUOTIENT formula will return the divide by zero formula (#DIV/0!)

 


5. The MOD Function

The MOD function is the opposite of the quotient function. Instead of retaining the quotient, the remainder is retained.

 Step 1: Write the numbers, the dividend in the first column, and the divisor in the second column.

Step 2: Write the formula =MOD(dividend,divisor) in the third column.

MOD column

Step 3: After writing the formula, click enter.

Step 4: If you have multiple numbers, you can use the same formula on each row or click on the first C2 cell, and on the bottom right, hover your mouse near the dot, a black cross will appear. Hold the left mouse and drag it down.

MOD results

Step 5: The results column will display the remainders in the division calculations.


6. Divide Using the Paste Function

Step 1: Write the numbers in columns A and B and the divisor in column D.

divisor column

Step 2: Click on Divisor 5 and copy using CTRL + V

Step 3: Highlight the results column from B2 to B6.

Step 4: Click CTRL + ALT + V, a dialog box will appear.

Highlight the results column

Step 5: Click OK, and the answers will be displayed in the results column.

answers results column


Final Thoughts

There are different methods that you can use to divide numbers in excel. You can choose a formula depending on the number of calculations you are doing. If you have many calculations, using a formula that calculates in bulk is the best alternative. Moreover, on the top menu bar under “Autosum,” you can still use the functions there to perform calculations. Make use of all the formulas to ensure you get accurate answers fast.

Leave a Reply

Your email address will not be published. Required fields are marked *