Answer

To divide in Excel, enter a formula that uses the forward-slash operator.

Division Formula

The division operator in Excel is /.
A standard division formula uses the format:

\text{= A1 / B1}

How to Perform Division Between Two Cells

1. Select the cell where the result will appear.

2. Type the equal sign.

3. Type the cell reference of the numerator.

4. Type the forward-slash.

5. Type the cell reference of the denominator.

6. Press Enter.

Example

To divide the value in cell A1 by the value in cell B1, enter:

= A1 / B1

How to Divide a Number by a Constant

1. Select a destination cell.

2. Type =, the number, /, and the constant.

3. Press Enter.

Example:

= 50 / 5

How to Apply Division to Multiple Cells

1. Select a cell with the division formula.

2. Drag the fill handle down or across.

3. Release the mouse to copy the formula with relative references.

Windows and Mac Differences

Windows and Mac use the same formula structure.
The keyboard shortcut for entering a formula is the same on both systems because typing the slash key does not vary across platforms.

Important Notes

1. Excel divides text-formatted numbers only after the cell format changes to Number or General.

2. A division by zero returns the error #DIV/0!.

3. A blank denominator cell is read as zero and returns the same error.

4. Excel recalculates division formulas automatically when either input value changes.

Yes · 0 No · 0 Add Comment · 0

Add ·

Report