To divide in Excel, enter a formula with a forward slash, such as =A2/B2, and press Enter. Replace A2 and B2 with the cells containing the numbers you want to divide. You can also divide a cell by a number, divide several rows by copying a formula down, or use a function such as QUOTIENT when you need only the whole-number part of a result.
What You’ll Need
- Excel for Microsoft 365 on Windows, or another recent version of Excel. The basic division operator works in Excel for Mac and Excel for the web too.
- A worksheet with the values you want to divide. Check which cell holds the number being divided (the numerator) and which holds the number you are dividing by (the denominator).
- A blank cell for the result. If you are calculating several results, plan to place the formula beside the first pair of values so you can fill it down.
Step-by-Step
- Identify the two numbers and their cells. For example, suppose A2 contains 24 and B2 contains 6. In this example, 24 is the numerator and 6 is the denominator. Excel will calculate the value in the first cell divided by the value in the second cell. Switching their order changes the result: 24 divided by 6 is 4, while 6 divided by 24 is 0.25.
- Select the cell where you want the answer. Click an empty cell, such as C2 in the example. You can enter a formula directly into the cell or click the formula bar above the worksheet. Starting with an equals sign tells Excel to calculate an expression rather than treat it as ordinary text.
- Type the division formula and press Enter. With 24 in A2, 6 in B2, and the answer intended for C2, enter
=A2/B2. Excel displays 4 in C2. The forward slash is the division operator; do not use a backslash or the word “divided.” The cell references tell Excel to use the current values in A2 and B2. - Divide a number by another number directly if you do not need cell references. In any blank cell, type
=24/6and press Enter. Excel returns 4. This approach is handy for a quick calculation, but a formula that points to worksheet cells is usually easier to update: changing a source value recalculates the answer automatically. - Divide a cell by a fixed number. If A2 contains 24 and you want to divide it by 6, enter
=A2/6in C2. The result is 4. You can also put the divisor in a separate cell, such as B2, and use=A2/B2; that makes the divisor easier to change without editing the formula. - Calculate results for a list of rows. Suppose A2:A5 contains amounts and B2:B5 contains the corresponding quantities. In C2, enter
=A2/B2. The result for that row is the amount in A2 divided by the quantity in B2. Select C2, then drag the small square at its lower-right corner (the fill handle) down through C5. Excel adjusts the relative references for each row, so C3 uses A3 and B3, C4 uses A4 and B4, and so on. Alternatively, select C2:C5 and choose Home > Fill > Down after entering the formula in C2. - Keep a divisor fixed while filling a formula down. If every value in A2:A5 must be divided by the constant stored in B1, use an absolute reference for B1. With values in A2:A5 and the fixed divisor in B1, enter
=A2/$B$1in C2, then fill down. The dollar signs lock both the column and row, so each copied formula continues to use B1. In Windows Excel, while editing a reference in a formula, press F4 to cycle through reference styles. On Mac, Command+T cycles reference styles in many current Excel configurations; if that shortcut differs on your keyboard, add the dollar signs manually. - Choose how many decimal places to show. Excel may display a rounded-looking result because of the cell’s number format, even when the stored calculation has more precision. Select the result cells and use Home > Number to choose a number format or adjust decimal places. Formatting changes what is displayed, not the underlying result. For a ratio or rate, select a format that makes the precision clear; for example, a displayed value of 3.5 may represent 3.5000.
- Use QUOTIENT only when you want to discard the remainder. With 17 in A2 and 5 in B2, enter
=QUOTIENT(A2,B2)in C2 to return 3, the integer portion of the division. The ordinary formula=A2/B2returns 3.4 instead. QUOTIENT is useful for grouping whole units, but it does not provide the remainder; use the standard slash formula when you need the full decimal result. - Save and verify the result. Check that the references point to the intended cells and that the numerator and denominator are in the correct order. For a quick check, multiply the result by the divisor; it should equal the original numerator, subject to rounding or the display format. Save the workbook using Ctrl+S on Windows or Command+S on Mac.
Common Mistakes
Using the wrong operator: Excel division uses the forward slash (/). A formula such as =A2\B2 is not the standard division formula. Use =A2/B2.
Reversing the order: Division is not commutative. The formula =A2/B2 is generally different from =B2/A2. Read the formula from left to right and confirm the first cell is the value you intend to divide.
Dividing by zero or a blank cell: A denominator of zero produces the #DIV/0! error. A blank denominator can also be treated as zero in this calculation. Confirm that the divisor contains a nonzero value before relying on the result.
Typing a formula as text: If the cell shows the characters =A2/B2 instead of a result, the cell may be formatted as Text, or the formula may have a leading apostrophe. Change the cell format to General, edit the formula, and press Enter. Simply changing the format may not recalculate text already entered as a formula.
Assuming displayed decimals are the full value: A cell formatted to show two decimal places can hide additional precision. This matters when totals or later calculations use the underlying value. Increase the displayed decimal places if you need to inspect the result more closely.
Tips
Use cell references rather than hard-coded numbers when the inputs might change. For example, keeping a price in one cell and a quantity in another makes the calculation easier to audit and update. Add clear column headings such as “Amount,” “Units,” and “Amount per unit” so you and other workbook users can understand what each number represents.
For a fixed divisor used in many rows, an absolute reference such as $B$1 prevents the reference from moving as you copy the formula. Use a relative reference such as A2 when each row should use its own value. If only the row or column should stay fixed, Excel also supports mixed references such as A$2 and $A2.
Do not round the formula just to make the cell look tidy. If the calculation should retain precision, change the number format instead. If the task genuinely requires a rounded result, Excel’s ROUND function can do that. With the unrounded quotient in C2 and a requirement to round it to two decimal places, enter =ROUND(C2,2) in D2. The second argument, 2, specifies the number of decimal places; use the formula only when rounding is part of the intended calculation.
To divide a total among equal groups, enter the total and group count in separate cells and divide those references. For instance, if A2 contains 96 and B2 contains 8, a formula in C2 of =A2/B2 returns 12 per group. If the group count can vary, keeping it in a cell is safer than embedding 8 in a formula.
Formulas recalculate when their referenced values change, provided calculation is not set to Manual. If results do not update, check Formulas > Calculation Options and select Automatic. This setting applies to the workbook’s calculations, so check before assuming a formula itself is wrong.
Troubleshooting
You see #DIV/0!: Inspect the denominator reference in the formula and the cell it points to. Confirm the divisor is a number other than zero. If a formula is filled down, a later row may contain a blank or zero even when the first row works. Correct the source data, or decide what the result should mean when no valid divisor is available.
If you prefer a blank result when the denominator is zero or blank, and A2 contains the numerator while B2 contains the denominator, enter this in C2: =IF(B2=0,"",A2/B2). Excel returns an empty-looking cell when B2 is zero or blank; otherwise it performs the division. This hides the error rather than fixing missing data, so use it only if a blank is an appropriate outcome. If you would rather show a message, replace the empty text between the quotation marks with a short message such as “Check divisor.”
The formula appears instead of a calculated answer: First check whether the cell is formatted as Text. Set it to General using Home > Number Format, then press F2 and Enter on Windows to re-enter the formula. On Mac, use Control+U to edit the active cell in many Excel configurations, then press Return; if your keyboard settings differ, click the formula bar and press Return. Also check that there is no apostrophe before the equals sign. If many cells show formulas, the worksheet may have Show Formulas enabled; toggle it from Formulas > Show Formulas.
The answer seems wrong after copying down: Click a result cell and inspect its formula. A relative reference should change with the row, while a fixed reference should retain dollar signs. If the divisor should stay in B1 but the copied formula points to B2 or B3, change the formula to use $B$1 and fill it down again. If a formula was dragged sideways or down too far, undo the fill or correct the affected cells.
The result has too few or too many decimal places: The number format may be rounding the display. Select the cell and increase or decrease decimal places in Home > Number. If the actual value must be rounded for a defined purpose, use ROUND rather than relying on how many digits happen to be visible. Compare the full formula result with the intended precision before sharing the workbook.
Excel rejects the formula or shows a warning: Check that it starts with an equals sign, uses a forward slash, and contains valid cell references, such as =A2/B2. If the source values were imported, they may be text rather than numbers; convert them to numeric values before calculating. If the formula uses a regional decimal separator, enter numbers using the separator configured for your Excel settings.
Frequently Asked Questions
What is the division symbol in Excel?
Use the forward slash (/). For example, with the number to divide in A2 and the divisor in B2, enter =A2/B2 in the result cell.
Can I divide an entire column in Excel?
Yes. Enter a formula beside the first row of data, then use the fill handle to copy it down. If the divisor changes by row, use relative references such as A2/B2. If every row uses one fixed divisor, lock that reference with dollar signs, such as =A2/$B$1.
How do I divide by a percentage?
Store the percentage as a percentage value in a cell and divide by that cell. For example, if A2 contains 50 and B2 contains 25%, =A2/B2 returns 200. Remember that 25% is stored as 0.25, so dividing by it produces a value four times as large as dividing by 1.
How do I show only whole-number division?
Use QUOTIENT when you want the integer portion and do not need the remainder. If A2 contains 17 and B2 contains 5, =QUOTIENT(A2,B2) returns 3. The ordinary division formula returns 3.4, so choose according to whether the decimal portion matters.
Why does Excel return #VALUE! when I divide?
One or both referenced cells may contain text that Excel cannot treat as a number, such as a label or an imported number stored as text. Check the source cells, remove unintended characters, and convert the values to numbers. Keep headings outside the rows used by the formula.
Does division work the same way on Mac and in Excel for the web?
Yes. The slash operator and cell-reference formulas work in Excel for Windows, Mac, and the web. Ribbon layouts and keyboard shortcuts can differ slightly, so use the formula bar or the relevant Home and Formulas ribbon commands if a shortcut does not match your device.
Related
- How to Delete Blank Cells in Excel Without Losing Data
- How to Delete an Excel File from a SharePoint Site
- How to Delete Blank Cells in Excel Safely
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel Formula to Capitalize Names: What PROPER Gets RightTo capitalize names in Excel, enter =PROPER(A2) in a helper column when the name is in A2. PROPER…
- Excel Filter Drop-Down Shortcut: Open It QuicklyIn Excel for Microsoft 365 on Windows, select a cell in the filtered column’s header row and press…
- Excel PV vs. NPV: Formulas, Examples, and DifferencesIn Excel, use PV to find the value today of a fixed series of equal payments, and use…
- Excel Formula to Calculate Percentage Change: ExamplesTo calculate percentage change in Excel, subtract the old value from the new value, then divide by the…
- Excel Not Equal to Blank: Formulas, Examples, and FixesTo test whether a cell is not blank in Excel, use the not-equal operator with an empty string:…
- Aggregate Excel Columns with Formulas and PivotTablesTo aggregate Excel columns, use a function such as SUM, AVERAGE, COUNT, MIN, or MAX across the cells…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.