Divide in Excel: Formulas, Examples, and Common Errors

Formulas & functions · Updated November 19, 2026

To divide in Excel, type an equals sign, enter the number or cell reference you want to divide, type the forward slash (/), then enter the divisor—for example, =20/4 returns 5. The slash is Excel’s division operator; there is no separate division function required for ordinary calculations.

The Division Operator in Excel

Excel uses the forward slash, also called a solidus, for division. On a standard keyboard, press the / key; a numeric keypad may have its own / key as well. Start a formula with = so Excel treats the entry as a calculation rather than text. You can divide typed numbers, cell references, or a combination of both.

No cell layout is needed for a calculation using constants: enter =20/4 in a cell, and Excel returns 5. Similarly, =7/2 returns 3.5. The result appears in the cell where you enter the formula, while the formula itself remains visible in the formula bar when that cell is selected.

Division follows the usual order of operations: multiplication and division are evaluated before addition and subtraction, from left to right. Use parentheses when you want a different order. For instance, with no cell references, =10+6/2 returns 13 because Excel divides 6 by 2 first. The formula =(10+6)/2 returns 8 because the parentheses make Excel add first.

Divide Cell Values with a Formula

Using references instead of typing numbers into every formula makes a worksheet easier to update. If the source values change, the result recalculates automatically. In Microsoft 365 for Windows, select the result cell, type =, select or type the first cell reference, enter /, select or type the second reference, and press Enter.

With 84 in A2 and 7 in B2, enter =A2/B2 in C2; the result is 12. The formula means “take the value in A2 and divide it by the value in B2.” If you change B2 to 6, C2 updates to 14. The same method works for values on other worksheets, although cross-sheet references need the sheet name as part of the reference.

To apply one calculation to many rows, write the formula in the first result row, then drag the small square at the lower-right corner of the selected cell (the fill handle) down the column. If A2:A4 contains 84, 45, and 96, and B2:B4 contains 7, 5, and 8, enter =A2/B2 in C2 and fill it down. Excel adjusts the references for each row, producing 12, 9, and 12. You can also copy the cell and paste it into the rows below.

Use Cell References and Lock Values When Needed

When a formula is copied, Excel normally changes relative references to match the new row or column. That is useful when each row has its own numerator and divisor, but it can be a problem when every row should be divided by one fixed cell. Add dollar signs to make a reference absolute so it stays fixed when you copy the formula.

With 84 in A2 and a fixed divisor of 7 in B2, enter =A2/$B$2 in C2. The result is 12. When you fill the formula down, A2 changes to A3, A4, and so on, while $B$2 continues to point to B2. A mixed reference locks only the column or row, such as $B2 or B$2, which can help when copying a formula across a table in one direction.

To change a reference while editing a formula, select the reference and press F4 on Windows to cycle through reference styles. On many Mac keyboards, use Command+T; keyboard settings can affect function-key behavior, so you may need to press Fn as well. You can also type the dollar signs yourself.

Divide by a Constant, Find a Quotient, or Get a Remainder

To divide a value by the same constant in several cells, enter the constant in one cell and use an absolute reference, or type the constant directly into each formula. A reference is easier to maintain if the divisor might change; a typed constant can be convenient for a one-off calculation. For example, to convert a set of values into half-sized values, divide each by 2.

Ordinary division can return a decimal. If you need only the whole-number portion of a division result, Excel’s QUOTIENT function returns the integer quotient and discards the remainder. With no cell layout needed because the inputs are typed directly, =QUOTIENT(17,5) returns 3. This is not the same as rounding 3.4 to the nearest whole number; it drops the fractional portion.

To find what remains after whole-number division, use MOD. With no cell layout needed for these typed inputs, =MOD(17,5) returns 2, because 5 goes into 17 three times with 2 left over. MOD is useful for checks such as identifying values that divide evenly: a remainder of zero means there is no remainder. For example, it can help group records into repeating cycles or check whether a count is an exact multiple of a chosen number.

Control Decimal Places and Display

Excel may calculate a precise decimal result but show fewer digits because of the cell’s number format. For example, a result such as 3.5 may display as 4 if the cell is formatted to show zero decimal places. The displayed value is rounded for presentation; changing the number format does not necessarily change the underlying result used in later calculations.

To change how a result looks, select the cell or range and use the number-format controls on the Home tab. Choose a suitable category, such as Number or Percentage, and adjust the decimal places with the increase or decrease decimal buttons. You can also open Format Cells with Ctrl+1 on Windows or Command+1 on Mac, then choose a number category and set its decimal places.

Use percentage formatting when the division represents a proportion. With 45 in A2 and 60 in B2, enter =A2/B2 in C2; the underlying result is 0.75. Format C2 as Percentage and it displays as 75%. Do not multiply by 100 and then apply percentage formatting, because that would display an inflated value such as 7,500%.

Fix #DIV/0! and Other Common Problems

The error #DIV/0! means the divisor is zero or refers to a blank cell. Excel cannot perform division by zero. Check that the divisor cell contains the intended value, that it was entered in the expected row, and that a formula has not returned zero unexpectedly. A cell that looks blank can also contain a formula returning zero or an empty string, so inspect the source rather than relying only on its appearance.

If a blank divisor should leave the result blank, add a condition. With the numerator in A2 and divisor in B2, where B2 may be blank or zero, enter =IF(B2=0,"",A2/B2) in C2. If B2 is zero or blank, C2 displays an empty string; otherwise, it returns the division result. This approach is clearer than showing an error, but it also means the worksheet no longer visibly flags a missing divisor.

Another option is to catch errors more generally. With the numerator in A2 and divisor in B2, enter =IFERROR(A2/B2,"") in C2. If the division produces an error, the cell displays blank; otherwise, it displays the result. IFERROR can also hide errors unrelated to division, so use it only when suppressing those errors is appropriate. If you need to diagnose a worksheet, leaving the error visible until you find its cause is often more useful.

If Excel displays the formula instead of a result, check whether the cell is formatted as Text or whether Show Formulas is turned on. Change a text-formatted cell to General, re-enter the formula, and make sure it begins with = rather than an apostrophe. Also check for a leading space before the equals sign. If a result seems wrong, verify the cell references, parentheses, and divisor; then check whether the displayed number is rounded by its format.

Division Compared with Other Excel Methods

For a normal quotient, the / operator is usually the simplest and clearest option. Excel does not require a dedicated DIVIDE function for basic division. QUOTIENT is useful when you specifically need the whole-number quotient, while MOD gives the remainder; neither replaces ordinary division when you need the full decimal result.

For a calculation involving several operations, use parentheses to make the intended order explicit. If you are calculating a total per person, for example, add the relevant amounts first and then divide by the number of people. Dividing each amount separately and adding the results may produce a different answer, particularly if rounding is involved. Keep the unrounded values in the formulas when possible, and use formatting to control what readers see.

In Excel for the web, the / operator and these standard formulas work in much the same way as in the Windows desktop app. On Mac, formulas use the same slash operator and cell-reference syntax; the main differences for the steps above are the keyboard shortcuts and some keyboard layouts. If the slash key is inconvenient, typing the character into the formula is sufficient.

Frequently Asked Questions

What is the divide key in Excel?
The division operator is the forward slash (/). Enter it between the value being divided and the divisor inside a formula that starts with an equals sign.

How do I divide two columns in Excel?
Put the division formula in the first result row using the two corresponding cells, then fill or copy it down. Excel updates relative row references as the formula moves.

How do I divide by a fixed number in Excel?
Type the number after the slash in each formula, or put it in a cell and lock that cell reference with dollar signs before copying the formula. Referencing a cell makes it easier to change the divisor later.

Why does Excel show #DIV/0!?
The formula is trying to divide by zero or by a blank cell. Check the divisor and decide whether the result should show an error, a warning, or a blank when no valid divisor is available.

How do I show a division result as a percentage?
Divide the numerator by the denominator, then format the result cell as Percentage. Excel converts a result such as 0.75 to 75% for display.

Can Excel divide and return only a whole number?
Yes. Use QUOTIENT when you want the integer quotient without the remainder, and use MOD when you want the remainder. Use the / operator when you need the full decimal result.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.