Microsoft Excel logo on a green background

Excel makes it easy to perform basic math operations, which includes division. You can divide numbers in a single cell, from multiple cells, or even entire columns. Since there’s no DIVIDE function in Excel, you’ll need to use a simple formula.

RELATED: Functions vs. Formulas in Microsoft Excel: What's the Difference?

Divide Numbers in a Single Cell

You can divide numbers in a single cell by entering a simple formula. Open Excel and select the cell you’d like to input the formula in. Once selected, enter this formula:

=a/b

Replace a and b with the numbers you’d like to use. So if you want to divide 100 by 4, you’d enter:

=100/4

Note that you must type the equal sign (=) at the beginning of the formula or Excel will interpret your input as a date.

Enter the numbers you want to divide in the single cell.

Press “Enter” and the result will appear.

The result of the division.

Divide Numbers From Multiple Cells

If you have data in multiple cells, you can input a simple formula in a blank cell to receive the quotient. For example, let’s say you have 100 in cell B2 and 4 in cell B3, and you want the quotient of these two figures. In a blank cell, enter:

=B2/B3

Enter the formula to receive the quotient of multiple cells.

Advertisement

This formula will pull the data from each cell for calculation. Press “Enter” and the result will appear.

The result of dividing data from two cells.

Divide a Column of Numbers (by a Constant Number)

You can divide a column of numbers by a number in a different cell. For example, let’s say cells A1-A6 each contain a number, and you want to divide those by the number contained in cell C1.

A column full of numbers.

First, select cell B2, which is where the output of the first formula will be. In B2, enter this formula:

=A1/$C$1

The formula that allows you to divide numbers in a column.

Press “Enter” and the result will appear.

What $ tells Excel in this case is that the number in cell C1 is absolute. This means if you click and drag the formula in B1 down, the A1 part of the formula will change to A2, A3, and so on, while C1 will remain the same.

To quickly get the quotient of the rest of the numbers in the column, click and drag the corner of cell B1 (called the fill handle) to repeat the formula for each cell.

That’s all there is to it.

This is just one of the basic calculations you can do in Excel. You can also multiply, add, subtract, and much more.

RELATED: How to Calculate Average in Microsoft Excel

Profile Photo for Marshall Gunnell Marshall Gunnell
Marshall is a writer with experience in the data storage industry. He worked at Synology, and most recently as CMO and technical staff writer at StorageReview. He's currently an API/Software Technical Writer based in Tokyo, Japan, runs VGKAMI and ITEnterpriser, and spends what little free time he has learning Japanese.
Read Full Bio »