To divide in Google Sheets, type an equals sign and use a forward slash, for example =A2/B2, then press Enter. You can also use the DIVIDE function, =DIVIDE(A2,B2), which gives the same result. If you only want the whole number part with no remainder, use QUOTIENT instead.
There's no divide button in Google Sheets, which surprises a lot of people the first time they go looking. Division is done with a formula, and the good news is it's the simplest formula there is: one cell, a slash, another cell. Here's how to do it, how to copy it down a whole column, and the error that stops most first attempts.
Divide two cells with the slash
- Click the cell where you want the answer.
- Type = to start a formula.
- Click the cell with the number you want to divide (for example A2).
- Type a forward slash /.
- Click the cell you're dividing by (for example B2), so the formula reads =A2/B2.
- Press Enter.
You can type plain numbers too. =8/2 gives 4. Mixing is fine as well: =A2/2 halves whatever is in A2.
The three ways to divide, side by side
| Method | Example | What you get |
|---|---|---|
| Slash operator | =A2/B2 | The full result, including decimals |
| DIVIDE function | =DIVIDE(A2,B2) | The same as the slash |
| QUOTIENT function | =QUOTIENT(A2,B2) | Only the whole number part, no remainder |
Google describes DIVIDE as equivalent to the slash operator, so there's no hidden extra power in it. I use the slash because it's shorter, but DIVIDE can be easier to read when you're showing a spreadsheet to someone who isn't comfortable with formulas.
The catch: QUOTIENT drops the remainder
This one trips people up because the help pages themselves don't quite agree. The DIVIDE page says DIVIDE is equivalent to QUOTIENT, but the QUOTIENT page is clear that QUOTIENT only returns the quotient and not the remainder, and says to use DIVIDE or the slash if you want the full result. In practice, if A2 holds 7 and B2 holds 2, =QUOTIENT(A2,B2) gives 3, while =A2/B2 shows 3 and a half as a decimal.
So use QUOTIENT when you want whole units, such as how many full boxes you can pack, and use the slash or DIVIDE everywhere else.
Divide a whole column in one go
You don't need to type the formula on every row. Write it once in the first row, then click the cell and drag the small blue square at its bottom right corner down the column. Sheets adjusts the references as it goes, so row 3 becomes =A3/B3 and so on.
Double-clicking that small square is even quicker on a long list: Sheets copies the formula down as far as the column next to it has data. Just glance at the last few rows afterwards to make sure it stopped where you expected, especially if your list has gaps.
If you want every row divided by the same number, the simplest route is to type that number straight into the formula, for example =A2/4, and copy it down. If the number might change later, put it in its own cell with a clear label next to it, so anyone reading the sheet can see where it comes from and update it in one place.
Dividing inside bigger formulas
Division often sits inside a longer calculation. Sheets follows the usual order of operations, so brackets matter. =(A2+B2)/C2 adds the two cells first and then divides the total, while =A2+B2/C2 divides B2 by C2 first and then adds A2. If a result looks oddly high or low, missing brackets are the first thing I'd check.
You can also nest DIVIDE inside other functions, such as wrapping it in ROUND to keep a set number of decimal places. Google lists DIVIDE alongside ADD, MINUS and MULTIPLY, which are the function versions of the plus, minus and times signs, so you can write a whole calculation in functions if that reads more clearly to your team.
Want AI doing the heavy lifting in your marketing?
I build the systems that handle the boring 80 percent, so you get your week back. Done properly, with the human kept in.
Fixing the divide by zero error
Google's help pages state that the divisor can't equal 0. If the cell you're dividing by is empty or zero, Sheets shows an error instead of an answer. Empty cells count as zero, which is why a half-filled column often fills up with errors.
The tidy fix is to wrap the formula in IFERROR, for example =IFERROR(A2/B2, ""), which shows a blank cell instead of the error. Do check why the divisor is empty first, though: hiding an error doesn't fix a missing number.
Turning a division into a percentage
A lot of division is really percentage work: completed tasks out of total tasks, replies out of emails sent. Divide as normal, then select the cells and click Format, Number, Percent. Sheets shows a half as a percentage without you multiplying by anything.
What I'd do
Use the slash for everyday division, QUOTIENT only when you want whole units and brackets whenever division sits inside a longer formula. Wrap formulas in IFERROR once your sheet is shared, so blank rows don't look broken. For the other everyday sums, see multiplying in Google Sheets and subtracting in Google Sheets.
Frequently asked questions
What is the divide formula in Google Sheets?
Use a forward slash between two cells or numbers, for example =A2/B2. The DIVIDE function, =DIVIDE(A2,B2), does the same thing.
Is there a DIVIDE function in Google Sheets?
Yes. DIVIDE(dividend, divisor) returns one number divided by another and is equivalent to the slash operator.
How do I divide without a remainder in Google Sheets?
Use QUOTIENT, for example =QUOTIENT(A2,B2). It returns only the whole number part of the result.
Why do I get an error when dividing in Google Sheets?
The cell you're dividing by is probably empty or zero. Google's help page says the divisor can't equal 0.
How do I divide a whole column by one number?
Write the formula in the first row, such as =A2/4, then drag the fill handle down the column to copy it to every row.
