How to Divide a Number in Excel Using Simple Formulas

Formulas & functions · Updated November 20, 2026

To divide a number in Excel, enter a formula with a forward slash: for example, if A2 contains 24 and B2 contains 6, type =A2/B2 in another cell and press Enter to get 4. You can divide cell values, a cell by a fixed number, or a whole column of numbers. You’ll need a worksheet with your numbers entered as values; Excel for Microsoft 365 on Windows is used for the steps below.

What You’ll Need

  • An Excel workbook open in Microsoft 365 for Windows. The same division formulas work in Excel for Mac and Excel for the web.
  • The number or numbers you want to divide, entered in cells. If you are dividing one cell by another, identify which cell holds the numerator and which holds the divisor.
  • An empty cell or column for the results, so you can keep the original values unchanged and check your calculations.

Step-by-Step

  1. Arrange the numbers and choose where the result will go. For a single calculation, you can put the number being divided (the dividend) in A2 and the number you are dividing by (the divisor) in B2. Leave C2 empty for the answer. For a list, use one column for the values to divide and a neighboring column for the divisors or results. Keeping results in a separate column makes it easier to review and reuse the original data.

  2. Select the cell for your first result. Click C2, or the empty cell where you want the answer. An Excel formula must begin with an equals sign. To divide the value in A2 by the value in B2, enter =A2/B2. With 24 in A2 and 6 in B2, this formula returns 4. The slash key is the division operator in Excel; do not use the ÷ symbol or the word DIVIDE in a basic formula.

  3. Press Enter and check the result. Excel calculates the formula and displays the answer in the selected cell. Click that cell once to see the formula in the formula bar. The cell shows the result, while the formula bar shows how Excel calculated it. If you change A2 or B2 later, the answer updates automatically. This is useful when the underlying numbers may be revised.

  4. Divide each row in a list. Suppose A2:A6 contains values to divide and B2:B6 contains matching divisors. In C2, enter =A2/B2, then press Enter. For example, if A2 is 45 and B2 is 5, C2 displays 9. The same formula structure works for each row because the row references adjust as you copy it. Make sure each numerator is paired with the divisor on the same row.

  5. Copy the formula down the column. Select C2 and point to the small square at the lower-right corner of its border, called the fill handle. Drag it down to C6. Excel adjusts the references for each row: the next row uses A3 divided by B3, then A4 divided by B4, and so on. You can also copy C2, select C3:C6, and paste. On Windows, use Ctrl+C and Ctrl+V; on Mac, use Command+C and Command+V. Check a couple of results against the source values before relying on the full column.

  6. Divide a cell by a fixed number. You can type the divisor directly into the formula when it will not change. If A2 contains 84, enter =A2/7 in B2; the result is 12. This is quick for a one-off calculation. If you plan to copy the formula down and might change the divisor, put the divisor in its own cell instead. A separate input cell makes the calculation easier to update and audit.

  7. Keep a divisor fixed when filling a formula. For a reusable worksheet, place the divisor 7 in B1 and the values to divide in A2:A6. In C2, enter =A2/$B$1. With A2 equal to 84 and B1 equal to 7, the result is 12. The dollar signs keep the reference to B1 fixed when you fill the formula down; A2 remains relative and changes to A3, A4, and so forth. To add the dollar signs while editing a reference, select the reference in the formula and press F4 on Windows. On a Mac, the shortcut can depend on the keyboard settings; you can type the dollar signs directly.

  8. Choose a display format if needed. Division can produce a decimal, such as 2.5, even when the input cells contain whole numbers. Excel normally displays the calculated value using the result cell’s current number format. To change how it appears, select the result cells and use Home > Number to choose a number format, or use Increase Decimal and Decrease Decimal to show more or fewer places. Formatting changes the displayed precision, not the underlying calculation. For example, a displayed 2.50 may still have more decimal places in the stored result.

Common Mistakes

  • Using the wrong operator. Excel uses a forward slash for division. Typing a ÷ sign or writing a sentence instead of a formula will not calculate the result. Begin with = and put / between the two numbers or cell references.

  • Reversing the order. Division is not interchangeable: 30 divided by 5 is 6, while 5 divided by 30 is about 0.167. Check that the first reference is the value being divided and the second is the divisor. A clear column heading, such as Amount to divide or Divisor, can prevent swapped inputs in a larger table.

  • Dividing by zero or a blank cell. A divisor of zero is undefined, and Excel displays #DIV/0!. A blank divisor cell can also trigger this error. Check the divisor values and correct missing data rather than treating the error as a valid result.

  • Letting a fixed reference move. When you fill a formula down, ordinary references move with each row. If every calculation should use the same divisor cell, use an absolute reference such as $B$1. Otherwise, the formula may start dividing by empty or unrelated cells.

  • Overwriting the source values too soon. Keeping results in a separate column preserves the inputs and makes checking easier. If you later need to replace formulas with fixed results, copy the result cells and use Home > Paste > Paste Values in a separate destination or after confirming the formulas are correct.

Tips

  • Use descriptive headings. Label the input and result columns so another person can tell what each number means. For example, headings such as Units, Units per pack, and Packs help explain why one column is divided by another.

  • Keep calculations auditable. Cell references make formulas easier to check than typing every number directly into a formula. A formula that refers to the visible input cells also updates if those inputs change. Use a fixed divisor in a clearly labeled cell when many rows share it.

  • Check a sample calculation manually. Pick one row and calculate it with a calculator or mental arithmetic. If the result does not match, inspect the row pairing, the divisor, and the formula references before filling the formula further.

  • Use number formatting rather than changing the formula to round the display. If you only need fewer visible decimal places, adjust the number format. Rounding the underlying value can affect later calculations, so do it only when your task specifically requires a rounded value.

  • Use the same method on Mac or the web. The slash operator and cell-reference formulas are the same in Excel for Mac and Excel for the web. Ribbon placement and keyboard shortcuts can vary slightly by platform, but the Windows formula steps above do not depend on a Windows-only feature.

Troubleshooting

  • You see #DIV/0!. Select the formula cell and inspect its divisor reference. Make sure that cell contains a nonzero number and is not blank. If the divisor is intended to be zero, decide how the worksheet should handle that case instead of accepting the error as a meaningful answer.

  • You see #VALUE!. One or both referenced cells may contain text rather than numbers. Look for entries such as a number with an extra space or an apostrophe before it. Select the affected cell and, if Excel offers a warning icon, choose Convert to Number. You can also review the imported data and remove nonnumeric characters before recalculating.

  • The formula appears as text instead of calculating. Confirm that it starts with = and that the result cell is not formatted as Text. Change the cell format to General from Home > Number, then re-enter the formula by selecting the cell, pressing F2, and pressing Enter. If there is an apostrophe before the equals sign, remove it.

  • The copied results are wrong or show errors. Click a result cell farther down the column and inspect the formula bar. Check whether the numerator and divisor references point to the intended row. If the divisor should stay in one cell, revise the formula to use an absolute reference such as $B$1, then fill it down again.

  • The answer looks rounded or unexpectedly small. The cell may be displaying only a few decimal places, or the inputs may be stored at a different scale than expected. Select the result and increase the displayed decimal places from Home > Number. Also check that the divisor is not larger than intended and that the source values use the same units.

Frequently Asked Questions

What is the division symbol in an Excel formula?
Use a forward slash (/). For example, enter =A2/B2 to divide the value in A2 by the value in B2.

Can I divide a number directly without using cell references?
Yes. Type the numbers into a formula with an equals sign and slash, such as =48/6. Excel returns 8. For a worksheet you will update, cell references are usually easier to maintain.

How do I divide every value in a column by the same number?
Put the common divisor in one cell, use an absolute reference to that cell in the first formula, and fill the formula down. For example, if the divisor is in B1 and the first value is in A2, use =A2/$B$1 in the result column.

Why does Excel show a decimal when I expect a whole number?
The division may not come out evenly. For instance, 10 divided by 4 equals 2.5. If you only want to change how many decimal places are displayed, select the result and adjust its number format; this does not change the underlying result.

How do I divide by zero in Excel?
You cannot get a defined numerical result from division by zero. Excel returns #DIV/0! when a formula’s divisor is zero or blank. Check the inputs and decide whether the missing or zero divisor should be corrected or handled separately in your worksheet.

Can I use the same division formulas in Excel for Mac?
Yes. Formulas such as =A2/B2 work in Excel for Mac and Excel for the web as well as Excel for Windows. Some keyboard shortcuts and ribbon details differ, but the division operator and cell-reference behavior are the same.

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.