Last Updated on November 1, 2023 by Jake Sheridan
In this tutorial, you will learn how to divide in Google Sheets.
How to Divide in Google Sheets
Google Sheets makes it easy to perform mathematical calculations on your data. One of the most common calculations you may need to do is division.
Whether you’re dividing a single cell or a range of cells, you can quickly get the results you need with the DIVIDE operator “/”.
In this guide, we will explain how to use this function and provide a few examples along the way.
We will also explain how to use the DIVIDE function and how to return an integer result.
How to Divide Values in Google Sheets
Here’s how to divide values in Google Sheets.
We’ll first explain how to use the divide operator. Select an empty cell and place an “=” to indicate that you want to start a formula.
In this example, we want to divide our number of participants by the desired number of groups to obtain the group size.
Type the cell reference to the numbers you want to divide. Use the “/” to indicate you want one cell to be divided by another.
In this example, we find out that the size of each group is 15.
We can achieve the same result by using the DIVIDE function.
Do note that the first argument is the number being divided (dividend) and the second argument is the number by which we divide (divisor).
Sometimes our division formula returns a decimal result
In some cases, having a decimal value does not make sense. We can return an integer or whole number by wrapping our division formula with an INT function.
In the example above, we converted the decimal result into a whole number since we want to know the number of people in each group.
This guide should be everything you need to divide in Google Sheets.
You may make a copy of this example spreadsheet to test it out on your own.
More basic math formulas in Google Sheets:
- AVERAGE Function
- MAX Function
- MIN Function
- FLATTEN Function
- GROWTH Function
- Transpose Data
- SORT Function
- How To Round
- How To Multiply
- How To Divide
- How To Subtract
- Round Down
- Add Cells
- Multiply Cells
- Subtract Cells
- Find Median
- Find Quartiles
- Automatically Add Numbers
- Find Mean
- Standard Deviation
- Find Average
- Find Range
- Find Variance
- T Test
- Use Pi In Google Sheets
- How To Square
- Square Root
- Sum Columns or Rows
- SUMPRODUCT Formula
- How To Create A Function
- How To Create Formula