Divide in Excel: Formula and Keyboard Tips

Formulas & functions · Updated November 19, 2026

To divide in Excel, type a forward slash (/) between the numbers or cell references in a formula, such as =A2/B2, then press Enter. On a standard keyboard, use the / key; on a numeric keypad, use its divide key. Excel uses the slash as its division operator, not the ÷ symbol.

The Excel division operator

Excel performs division with the forward slash, the same symbol used in web addresses. A formula must begin with an equals sign, which tells Excel to calculate rather than display the entry as ordinary text. Put the number or cell reference being divided before the slash and the divisor after it: for example, =20/4 returns 5.

The symbol you see on a keyboard depends on its layout. On many US keyboards, the slash shares a key with the question mark: press the key without Shift to enter /, and with Shift to enter ?. A numeric keypad usually has a separate / key. Other keyboard layouts may place the character elsewhere, but the formula itself is unchanged. The ÷ symbol can appear in text or a worksheet label, but it is not Excel’s arithmetic division operator in a formula.

For Microsoft Excel for Microsoft 365 on Windows, the basic process is the same whether you type a formula directly into a cell or into the formula bar. Excel for Mac and Excel for the web also use / for division; the slash key’s physical position can vary with the keyboard layout.

How to divide two cells

A cell-reference formula is usually preferable to typing the underlying numbers into a calculation. It updates automatically if either input changes, and it makes the calculation easier to check later.

  1. Select the cell where you want the answer to appear.
  2. Type =, select or type the first cell reference, enter /, and select or type the second reference.
  3. Press Enter to calculate the result.

With the values 24 in A2 and 6 in B2, enter =A2/B2 in C2. Excel returns 4. You can type the references yourself or click the cells while composing the formula; Excel inserts their references for you. If you use the mouse, click the first cell, type the slash, and click the second cell before pressing Enter.

For a column of calculations, enter the formula in the first result row and copy it down. With the dividend in A2:A6 and the divisor in B2:B6, enter =A2/B2 in C2, then fill the formula down the column. Excel adjusts the relative references as it copies: in C3, the formula becomes =A3/B3. On Windows, select the formula cell and the cells below it, then press Ctrl+D to fill down. On Mac, the corresponding shortcut is Command+D. You can also drag the fill handle at the selected cell’s lower-right corner.

Divide a number by another number or a constant

You do not need cell references for every calculation. For a one-off result, enter the values directly in a formula. =84/7 returns 12. If one value is likely to change, putting it in a cell makes the calculation easier to maintain: a formula can refer to the input cell rather than requiring you to edit the formula itself.

To divide a list of values by the same constant, use a cell reference for each changing value and type the constant in the formula. With 24 in C2, =C2/3 returns 8. Copying that formula down changes C2 to C3, C4, and so on, while the divisor stays 3. This is useful for scaling quantities, converting totals to per-unit amounts, or splitting a total into equal portions.

Division can also express a rate or unit amount. For example, if a total quantity is in A2 and the number of items is in B2, dividing the total by the item count gives the amount per item. With 875 in A2 and 25 in B2, =A2/B2 returns 35. The result’s meaning and units depend on what the inputs represent, so label the result column clearly rather than relying on the formula to explain itself.

Order of operations and longer formulas

In a formula with multiple operators, Excel follows its order of operations. Multiplication and division are evaluated before addition and subtraction, and operations of equal precedence are evaluated from left to right. Parentheses let you make the intended grouping explicit.

For example, =18/3+2 returns 8: Excel divides 18 by 3 first, then adds 2. But =18/(3+2) returns 3.6 because the parentheses make Excel add 3 and 2 before dividing. If the formula is part of a report or is likely to be reviewed by someone else, parentheses can improve readability even when they are not strictly necessary.

To divide a total by a sum of several values, put the sum in parentheses. If A2 contains a total and B2:B4 contain component values, the calculation can be written as =A2/(B2+B3+B4). For a longer range, using a sum function can be clearer: with the total in A2 and the values in B2:B10, =A2/SUM(B2:B10) divides A2 by their combined total. Check that the denominator represents the whole amount you intend to use.

Copying formulas with fixed references

When you copy a formula, Excel normally adjusts cell references to match the new location. This is called a relative reference. It is helpful when each row has its own numerator and denominator, but it can be a problem when every row should divide by the same cell.

Suppose A2:A6 contains amounts and D1 contains a fixed divisor. With the amount in A2 and the divisor in D1, enter =A2/$D$1 in B2. The dollar signs lock both the column and row of D1, so filling the formula down changes A2 to A3, A4, and so forth, but keeps the divisor at D1. Without the dollar signs, the reference would shift as the formula is copied.

In Excel for Windows, while editing a formula, select a cell reference and press F4 to cycle through relative and absolute reference styles. Laptop keyboards may require the Fn key as well, depending on their function-key settings. On Mac, the shortcut can depend on the keyboard and system settings; you can always type the dollar signs directly. A reference such as $D$1 fixes both parts, while D$1 fixes only the row and $D1 fixes only the column.

Rounding, whole-number results, and remainders

Division can produce a decimal. If A2 contains 10 and B2 contains 3, =A2/B2 returns approximately 3.333333333, subject to the cell’s number format. Formatting a cell to show fewer decimal places changes how the result appears, not the underlying stored value used in later calculations.

If you need the calculated result rounded to two decimal places, use the ROUND function. With 10 in A2 and 3 in B2, enter =ROUND(A2/B2,2); it returns 3.33. This is different from merely hiding decimal places with a number format, which leaves the unrounded value available to other formulas. Choose the approach that suits the calculation: displayed precision and mathematically rounded values are not always interchangeable.

For whole-number division with a remainder, Excel provides QUOTIENT and MOD. With 17 in A2 and 5 in B2, =QUOTIENT(A2,B2) returns 3, the integer portion of the quotient, and =MOD(A2,B2) returns 2, the remainder. These functions are useful for tasks such as grouping items into full sets and finding how many are left over. They do not replace ordinary division when you need a decimal result.

Fixing #DIV/0! and other unexpected results

The most common division error is #DIV/0!. Excel shows it when the divisor is zero or refers to an empty cell that is treated as zero in the calculation. Check the denominator cell, confirm that the formula points to the intended row or column, and make sure the input data has been entered. A copied formula can also produce this error if a relative reference shifted to a blank or zero-valued cell.

If a zero divisor is meaningful and should produce a blank result, you can test the denominator first. With the numerator in A2 and denominator in B2, enter =IF(B2=0,"",A2/B2). The formula returns a blank-looking empty string when B2 is zero; otherwise, it divides A2 by B2. This also returns blank when B2 is empty, because Excel treats that reference as zero in the test.

Another option is IFERROR. With the calculation in A2 divided by B2, =IFERROR(A2/B2,"") returns a blank-looking result if the division produces an error. However, IFERROR catches errors beyond division by zero, which can conceal other problems in a workbook. If you want to identify missing or invalid inputs, it is often better to check the data and let the error remain visible until it is fixed.

If Excel displays the formula itself instead of a result, check that the cell is not formatted as Text and that the entry begins with =. Change the cell format to General if needed, then re-enter the formula. Also check whether Show Formulas is enabled; on Windows, Ctrl+` toggles formula display in many Excel configurations. The accent-grave key is commonly near the upper-left of a US keyboard. If the result looks rounded, adjust the number format or use ROUND only when the calculation itself should be rounded.

Keyboard tips and alternatives

There is no special division-only shortcut required in Excel: type the formula using the slash key and press Enter. On Windows, Enter completes the formula; on Mac, Return or Enter may complete it depending on the keyboard. The basic slash operator works in Excel for Microsoft 365 on Windows, Mac, and the web. A numeric keypad’s divide key can be convenient for entering formulas with numbers, but it has the same role as the slash character in the formula.

If you are entering a formula into a range, Ctrl+D on Windows or Command+D on Mac fills the top cell’s formula down through the selected range. That is a general fill command, not a divide command, and it is useful only when the references should adjust as Excel copies them. For a single calculation, typing =A2/B2 is often the clearest method.

For a whole-number quotient and remainder, QUOTIENT and MOD are alternatives to ordinary division, but they answer different questions. For a decimal answer, use /. For an integer quotient, use QUOTIENT; for the remainder, use MOD. There is no need to convert values to the ÷ character or to install an add-in to perform standard division.

Frequently Asked Questions

What key divides in Excel?
Use the forward slash key (/) in a formula. For example, type =A1/B1 and press Enter. A numeric keypad’s divide key also enters the division operator.

Can I use the ÷ symbol in an Excel formula?
No. Excel’s arithmetic division operator is the forward slash, /. The ÷ character can be used as displayed text, but write a slash in the formula if you want Excel to calculate a division.

How do I divide a column by one number?
Put the number in a cell and use a formula that references it. If values begin in A2 and the fixed divisor is in D1, enter =A2/$D$1 in the result row and fill it down. The dollar signs keep the divisor reference fixed.

Why does Excel show #DIV/0!?
The formula is dividing by zero or by a blank cell treated as zero. Check the denominator and the copied references. If a blank result is appropriate for zero denominators, use an IF test or IFERROR, while making sure you do not hide errors you need to investigate.

How do I divide and show only two decimal places?
To round the calculated value, use ROUND with two decimal places, such as =ROUND(A2/B2,2). To change only the display, format the result cell to show two decimal places; that does not change the underlying value.

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.