To divide in Excel without a function, enter a formula that starts with an equals sign and uses the slash operator: for example, with the number to divide in A2 and the divisor in B2, type =A2/B2 in another cell and press Enter. Excel calculates the result directly; you do not need a DIVIDE function.
This method works in Microsoft Excel for Microsoft 365 on Windows, and the same slash operator works in Excel for Mac and Excel for the web. Before starting, decide which cells contain the numbers and where you want the result. You can divide typed numbers, cell references, or a mixture of both.
What You’ll Need
- An Excel workbook with two numbers, or cells where you can enter them.
- A blank cell for the answer.
- The slash key, usually on the same key as the question mark. Use the regular forward slash, not a backslash.
Step-by-Step
- Enter the values you want to divide. Put the number being divided, called the dividend, in one cell and the number you are dividing by, called the divisor, in another. For a quick example, enter 24 in A2 and 6 in B2. You can also use values already in your worksheet; the examples below assume the dividend is in A2 and the divisor is in B2.
- Select the cell for the result. Click an empty cell where the answer should appear, such as C2. Keep the result in a different cell from either input so you can review or change the original values without overwriting them.
- Start the formula with an equals sign. In the result cell, type
=. Excel uses the equals sign to recognize that what follows is a calculation, rather than text to display as entered. - Enter the dividend, a slash, and the divisor. With the dividend in A2 and the divisor in B2, type
=A2/B2into C2. The slash means division. Do not put a space in place of the slash, and do not add a function name. - Press Enter to calculate. If A2 contains 24 and B2 contains 6, the formula returns 4 in C2. The formula remains visible in the formula bar when C2 is selected, while the cell normally displays the calculated result.
- Divide numbers typed directly into a formula if you prefer. This is useful for a one-off calculation that does not need to refer to worksheet data. Type
=24/6in a blank cell and press Enter; the result is 4. For changing data, cell references are usually more practical because you can update the inputs and let Excel recalculate. - Use a mixed calculation when needed. You can use a number and a cell reference in the same division formula. For example, if B2 contains 6, enter
=24/B2in C2 to return 4. If A2 contains 24 instead, enter=A2/6in C2, which also returns 4. Check that the literal number or referenced cell is the value you intend to use as the divisor. - Copy the calculation down a list. If each row has a dividend in column A and a divisor in column B, enter
=A2/B2in C2. Select C2, then drag the small square at the bottom-right corner of the cell down the column. Excel adjusts the references for each row, so the next row uses A3 divided by B3. On Windows, you can also select the formula cell and the cells below it, then press Ctrl+D. On Mac, the equivalent fill-down shortcut is Command+D. - Keep one input fixed when copying, if appropriate. Suppose each value in A2:A10 must be divided by a single rate in B1. With the value to divide in A2 and the fixed divisor in B1, enter
=A2/$B$1in C2. The dollar signs make B1 an absolute reference, so copying the formula down changes A2 to A3, A4, and so on, but keeps the divisor at B1. To set the dollar signs while editing a reference, Windows Excel commonly uses F4; on Mac, the shortcut can depend on the keyboard and Excel settings, so you can type the dollar signs directly. - Choose how the result should display. Excel may show a long decimal, or it may show a rounded-looking value because of the cell’s number format. Select the result cell or range, then use Home > Number to choose a display format such as Number or Percentage. Formatting changes how a value appears, not the underlying calculation. If the answer is a ratio or rate, select a format that suits what the result represents.
The order of the references matters: A2/B2 means the value in A2 divided by the value in B2. Reversing them produces a different answer. For instance, with A2 containing 24 and B2 containing 6, A2/B2 is 4, while B2/A2 is 0.25. Before copying a formula or sharing the result, check that the numerator and denominator are in the intended positions.
Common Mistakes
- Forgetting the equals sign. If you type 24/6 without an equals sign, Excel may treat the entry as text or interpret it according to the cell’s format rather than calculate it. Begin each calculation with =.
- Using a backslash or the wrong symbol. Excel division uses the forward slash /. A backslash is not the division operator. If the formula does not calculate, edit the cell and check the character between the two values.
- Reversing the inputs. Dividing a divisor by a dividend is not equivalent to dividing the dividend by the divisor. Confirm the first reference is the value being split and the second is the value to divide by.
- Dividing by zero or a blank cell. A zero divisor is undefined in Excel and produces the error
#DIV/0!. A blank referenced divisor is also treated as zero for this calculation. Enter a valid nonzero divisor or decide how your worksheet should handle missing data. - Copying a formula with the wrong reference behavior. Relative references change as you fill a formula down or across. This is helpful for row-by-row calculations but can move a shared rate reference accidentally. Use an absolute reference such as $B$1 for a value that should stay fixed.
- Rounding the display and assuming the value changed. Showing two decimal places does not necessarily round the stored result to two decimal places. The underlying value can retain more precision and affect later calculations. If a calculation truly needs a rounded value, use a separate rounding formula only when that requirement is clear.
- Overwriting an input cell. Placing the formula in A2 or B2 when that cell contains an input replaces the value you wanted to use. Put the result in a separate cell and label the columns if the sheet will be reused.
Tips
- Use references for repeatable work. A formula linked to input cells updates when those inputs change. A formula with typed numbers does not follow changes elsewhere in the worksheet.
- Label the columns. Headings such as Amount, Units, and Amount per unit make it easier to see which value is the dividend and which is the divisor, especially when a workbook has many calculations.
- Check a result with easy numbers. If practical, test the formula using values with a known answer, such as 24 divided by 6. This can reveal reversed references or a formula copied from the wrong row.
- Use parentheses when the calculation includes other operators. Excel follows standard operator precedence, so multiplication and division are evaluated before addition and subtraction. Parentheses make the intended order explicit when a formula combines operations. For example, with A2 as a total and B2 as a count, a direct division remains straightforward; a larger expression may need grouping to make its meaning clear.
- Separate the value from its display. Keep the result numeric if you want to use it in later calculations. Avoid typing units or explanatory words directly into the formula cell; put those in a neighboring label cell or apply an appropriate number format.
- Remember that the formula works across platforms. Excel for Mac and Excel for the web use the same slash operator and cell-reference syntax. Ribbon layouts can vary, but you can enter or edit the formula directly in the cell or formula bar.
Troubleshooting
The cell shows #DIV/0!. Check the divisor reference in the formula. Make sure it points to a cell containing a number other than zero, and confirm that the cell is not blank. If a missing divisor is expected, correct the input or decide on a clear blank-result policy rather than treating the error as a valid answer.
The formula appears in the cell instead of an answer. First check whether the entry begins with an apostrophe or whether the cell is formatted as Text. Change the cell format to General using Home > Number Format, then edit the entry and press Enter again. Merely changing the format may not recalculate a value already stored as text; re-entering the formula usually prompts Excel to evaluate it. Also check that Show Formulas is not turned on. On Windows, Ctrl+` toggles formula display; on Mac, the shortcut can vary by keyboard, so check the Formulas tab for Show Formulas.
The answer looks too small, too large, or rounded. Check the formula references first, then inspect the number format and the value in the formula bar. A percentage format multiplies the displayed number by 100 and adds a percent sign, so a result of 0.25 appears as 25%. Choose a number format that matches the intended meaning of the calculation.
The formula returns #VALUE! or another unexpected error. Look at both referenced cells for text, stray spaces, or entries that look like numbers but are stored as text. Replace the entries with numeric values if appropriate, and check that the formula does not point to a heading or a text note. If the input is deliberately text, convert or clean it before using it in arithmetic.
Copied rows keep using the wrong divisor. Select one of the copied formulas and inspect its references in the formula bar. If the divisor should change by row, use a relative reference such as B2. If it should remain fixed, lock it as $B$1. Correct the first formula, then fill it down again.
Excel does not update after an input changes. Confirm that the calculation setting is automatic by opening Formulas > Calculation Options and selecting Automatic. If calculation is set to Manual, press F9 on Windows to recalculate. On Mac, use Formulas > Calculate Now if available in the current ribbon layout.
Frequently Asked Questions
Does Excel have a DIVIDE function?
No. In a normal worksheet formula, use the slash operator between the dividend and divisor. For example, with the dividend in A2 and the divisor in B2, =A2/B2 divides the first value by the second.
Can I divide one column by another?
Yes. If row 2 has the first value in A2 and the divisor in B2, enter =A2/B2 in C2, then fill the formula down. Each row calculates its own division when the references are relative.
How do I divide by a fixed number?
Type the number after the slash, or put it in a cell and use an absolute reference if you will copy the formula. With A2 as the value and 5 as the fixed divisor, =A2/5 returns one-fifth of A2.
Can I divide by zero in Excel?
No. Division by zero is undefined, so Excel displays #DIV/0!. A blank cell used as the divisor can produce the same error. Check the input or decide how to handle missing values.
How do I show a division result as a percentage?
Enter the division formula, select the result cell, and choose Home > Number > Percent Style. For example, with the part in A2 and the total in B2, =A2/B2 returns a ratio; if A2 is 1 and B2 is 4, the result is 0.25, displayed as 25% with percentage formatting.
Can I divide in Excel for Mac or the web without changing the formula?
Yes. The forward slash and cell-reference syntax are the same in Excel for Windows, Mac, and the web. Some ribbon locations and keyboard shortcuts differ, but the calculation itself does not.
Related
- How to Delete Duplicate Values in Excel Without Losing Data
- How to Delete Empty Rows in Excel Without Losing Data
- How to Delete Duplicate Lines in Excel
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- INDEX MATCH Examples: Exact, Two-Way, and Flexible LookupsWith product names in A2:A6, prices in B2:B6, and the product to find in E2, use =INDEX($B$2:$B$6,MATCH(E2,$A$2:$A$6,0)). If…
- LARGE and SMALL Excel Formulas: Find Ranked ValuesUse Excel’s LARGE and SMALL functions to return the value at a chosen rank in a set of…
- Excel MID Formula: Extract Text by PositionUse Excel’s MID function to extract a specified number of characters from a text value, starting at a…
- COUNTIF for Text: Exact Matches, Wildcards, and TipsTo count cells that exactly match text in Excel, use =COUNTIF(A2:A7,"East"). It counts matching entries in A2:A7 without…
- How to Filter an Excel Sheet by Text: Steps and TipsTo filter an Excel sheet by text in Microsoft 365 for Windows, select a cell in your data…
- Excel Formula for Date Range: Count Dates and MatchFor dates in A2:A100 and a start date in D2 and end date in E2, count dates in…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.