To divide two cells in Excel, use a forward slash in a formula: with the dividend in A1 and the divisor in B1, enter =A1/B1 in another cell. Excel calculates the result when you press Enter; for example, if A1 contains 12 and B1 contains 3, the result is 4.
The Basic Division Formula
Excel uses the slash character (/) as its division operator. The cell reference before the slash is the number being divided, and the reference after it is the number you divide by. The order matters: reversing the references changes the calculation.
For example, with 12 in A1 and 3 in B1, the formula =A1/B1 returns 4, while =B1/A1 returns 0.25. The equal sign at the beginning tells Excel to calculate an expression rather than display it as ordinary text. A division formula can use references to cells on the same worksheet or to cells elsewhere in the workbook.
There is no need to look for a dedicated DIVIDE function for ordinary cell division. The slash operator is the standard, direct way to divide values in an Excel formula. It can also be combined with other operators and functions when a calculation needs additional steps.
How to Enter and Copy the Formula
To enter a basic formula in Excel for Microsoft 365 on Windows, select the cell where you want the answer, type the formula, and press Enter. For a calculation using A2 as the dividend and B2 as the divisor, enter =A2/B2 in C2. If A2 contains 45 and B2 contains 5, C2 displays 9.
If you have a row of values to divide, you can copy the formula down the column. Select C2 and drag the small square at the lower-right corner of the selection (the fill handle) down through the rows you want to calculate. With a formula in C2 based on A2 and B2, Excel adjusts the references in the copied rows: the next row uses A3 and B3, then A4 and B4, and so on.
You can also copy and paste the formula into other cells. Relative references adjust to the formula’s new position by default. This behavior is useful for repeating calculations, but it is important to check that the references still point to the intended cells after copying.
The same slash-based formula works in Excel for Mac and Excel for the web. The interface and some keyboard shortcuts can differ, but the formula syntax does not change. If the result appears as text instead of a calculation, check that the cell is not formatted as Text, then re-enter the formula after changing the cell’s format to General or a suitable number format.
Worked Examples for Common Tasks
Division is often used to calculate a unit price, a rate, or a share of a total. The formula stays the same; what changes is the meaning of the values in the referenced cells. Labeling the columns clearly helps prevent accidentally dividing the wrong quantities.
- Unit price: With total cost in B2 and quantity in C2, enter
=B2/C2in D2. If B2 is 48 and C2 is 6, the result is 8 per item. Apply a currency format to D2 if the result represents money. - Average per day: With total distance in B2 and number of days in C2, enter
=B2/C2in D2. If the distance is 210 and the number of days is 7, the result is 30 distance units per day. - One value as a share of another: With the part in B2 and the total in C2, enter
=B2/C2in D2. If B2 is 15 and C2 is 60, the result is 0.25, or 25% when D2 is formatted as a percentage.
These are arithmetic examples, not advice about pricing or financial decisions. For money calculations, use the actual amounts and units that apply to the situation, and check relevant terms with the lender or a qualified professional when the calculation relates to a loan or another financial product.
Cell References and Fixed Divisors
By default, references such as A2 and B2 are relative. When a formula is copied, Excel shifts them to match the destination row or column. This is usually what you want when each row contains a separate pair of values to divide.
Sometimes every row should be divided by one fixed value, such as a conversion factor stored in F1. With the values to divide in A2:A10 and the constant divisor in F1, enter =A2/$F$1 in B2 and copy it down. The dollar signs make both the column and row of F1 absolute, so the divisor remains F1 as the formula is filled to other rows. If A2 is 20 and F1 is 4, the result in B2 is 5.
Without the dollar signs, copying a formula down can shift the divisor reference. For example, a reference to F1 might become F2 in the next row, which is wrong if the fixed value exists only in F1. You can lock a reference by adding dollar signs directly, or use F4 while editing a cell reference on Windows. On Mac, the equivalent key depends on the keyboard and system settings; inserting the dollar signs manually works across versions.
References can also point to another worksheet. If the divisor is on a sheet named Rates, Excel can refer to it as Rates!B2 when the sheet name has no spaces. A sheet name containing spaces needs single quotation marks around the name, as in 'Annual Rates'!B2. The division operator itself remains unchanged.
Division by Zero, Blank Cells, and Errors
A denominator cannot be zero in ordinary arithmetic. If the divisor cell contains 0, Excel returns the #DIV/0! error. A blank cell used as the divisor is treated as zero in this division context, so it can produce the same error. Before hiding or handling the error, check whether the zero or blank value indicates missing data, an incorrect entry, or a genuine zero.
To display a message instead of attempting division when B2 is zero, use this formula in C2, with the numerator in A2 and the divisor in B2: =IF(B2=0,"Cannot divide by zero",A2/B2). If B2 is zero or blank, C2 displays the message; if A2 is 12 and B2 is 3, the result is 4. The test covers a blank divisor as well as a numeric zero.
If you would rather leave the result cell empty when the divisor is zero, use this formula in C2, assuming A2 contains the numerator and B2 contains the divisor: =IF(B2=0,"",A2/B2). With B2 equal to zero or blank, the displayed result is empty; with A2 equal to 12 and B2 equal to 3, it returns 4. An empty-looking result can make a report cleaner, but it can also conceal missing data, so choose it only when that behavior is appropriate.
IFERROR is another option, but it handles more than division-by-zero errors. With the numerator in A2 and divisor in B2, this formula in C2 replaces any error in the attempted calculation with the text message: =IFERROR(A2/B2,"Check the values"). A valid input of 12 divided by 3 returns 4; a zero divisor displays the message. Because other errors are also caught, a targeted IF test may be preferable when you want to diagnose different problems separately.
Formatting the Result and Understanding Decimals
Excel stores the numerical result of a division independently of how that result is displayed. If 1 is divided by 3, the underlying result is a repeating decimal, while the cell may show a rounded value such as 0.33. Changing the number of displayed decimal places changes the appearance, not the underlying calculation. Use the increase or decrease decimal controls in the Home tab’s Number group when you need more or fewer visible places.
For a percentage, format the result cell as Percentage using Home > Number group > Percentage. If the part is 15 in B2 and the total is 60 in C2, with the formula =B2/C2 in D2, the underlying result is 0.25 and the percentage display is 25%. Excel does not require you to multiply by 100 when using percentage formatting; the format displays the decimal as a percentage.
That distinction prevents a common mistake. If you multiply the ratio by 100 and also apply percentage formatting, the displayed figure will be 2,500% rather than 25%. Choose either a decimal ratio multiplied by 100 for a plain numeric result, or the unmultiplied ratio with percentage formatting, depending on the output you need.
For money, apply a currency or accounting number format to the result rather than adding a currency symbol to the formula. For counts or measurements, use a number format with an appropriate number of decimal places. Formatting makes results easier to read, but it does not change the division being calculated.
Related Calculations: Quotients and Remainders
Ordinary division returns a quotient that can include a decimal. If you need only the integer portion of a quotient, Excel provides the QUOTIENT function. With 17 in A2 and 5 in B2, enter =QUOTIENT(A2,B2) in C2; the result is 3. This is different from simply displaying a regular division result with zero decimal places, because the displayed value may be rounded while the underlying value still contains a fraction.
To find what remains after dividing one integer by another, use MOD. With 17 in A2 and 5 in B2, enter =MOD(A2,B2) in C2; the result is 2, because 5 goes into 17 three times with 2 left over. These functions are useful for tasks such as grouping items into equal-sized batches, but they are not substitutes for ordinary division when you need the full decimal result.
Parentheses can clarify a calculation that combines division with other operations. Excel follows its standard order of operations, so multiplication and division are calculated before addition and subtraction, unless parentheses specify otherwise. For example, if you intend to divide a total by the sum of two values, put the addition inside parentheses rather than assuming Excel will group it automatically.
Common Problems and Quick Checks
If the answer looks wrong, inspect the inputs and the formula before changing the formatting. A result that is much larger or smaller than expected often comes from reversed references, an incorrect row, a hidden decimal, or a denominator that is not the value you intended.
- Click the result cell and read the formula in the formula bar. Confirm that the numerator appears before the slash and that the denominator appears after it.
- Check whether the divisor is zero, blank, or stored in a different row than expected. A visible cell can also contain a formula whose displayed result is zero.
- Look for a green error indicator or a result such as
#DIV/0!. Identify the cause before choosing a formula that hides the error. - If Excel shows the formula characters instead of a result, check for Text formatting or a leading apostrophe. Set the cell to General and enter the formula again.
- If copied formulas use the wrong divisor, check whether a reference needs dollar signs to stay fixed.
Also verify the units. Dividing centimeters by seconds produces a rate in centimeters per second, not a distance or a time. Excel performs the arithmetic but does not know whether the selected cells have compatible meanings, so clear headings and consistent units are part of making a spreadsheet reliable.
Frequently Asked Questions
What is the symbol for division in Excel?
Use the forward slash, /, between the two cell references. A formula must also begin with an equal sign.
Can I divide two cells without using a function?
Yes. The slash operator performs ordinary division directly; a separate function is not required.
Why does Excel show #DIV/0!?
The divisor is zero or blank, or the formula refers to a cell that evaluates to zero. Check the denominator and decide whether to correct the data or handle that case with an IF formula.
How do I divide a whole column of values?
Enter a formula in the first result row and fill it down. Excel adjusts relative references for each row; lock any reference that must stay fixed with dollar signs.
How do I show a division result as a percentage?
Divide the part by the total, then format the result cell as Percentage. For a part of 15 and a total of 60, the decimal result 0.25 displays as 25%.
Related
- Data Validation Named Range in Excel: Setup and Fixes
- Data Validation Reference Table in Excel
- Remove Duplicates in Power Query: A Practical Guide
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- DAX Formula in Excel to Remove Duplicates: What WorksThere is no DAX formula in an Excel worksheet that deletes duplicate rows. For a live list of…
- Excel Formula for Budget Amount RemainingIf your total budget is in B2 and the amount spent is in C2, enter =B2-C2 in another…
- How to Remove Spaces in Excel With TRIM and SUBSTITUTETo clean extra spaces in Excel, use TRIM; to delete every ordinary space, use SUBSTITUTE. With the original…
- PowerPoint Poster Slide Size: Set the Right DimensionsTo change a PowerPoint slide to poster size in Microsoft 365 for Windows, select Design > Slide Size…
- Excel COUNT Formula Examples: Numbers, Blanks, and TextIn Excel for Microsoft 365, use =COUNT(A2:A20) to count cells containing numbers, including dates and times. For other…
- Rows in Excel Nederlands: Meaning and the RIJEN FunctionIn Dutch, Excel rows are called rijen; the English Excel function ROWS is named RIJEN in Dutch-language Excel.…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.