How to divide numbers in Google Sheets
Commission may be earned if you purchase through links on this site - learn more
Let’s take a look at how to divide numbers in Google Sheets. To divide a number in Google Sheets you use ‘/’ in the formula to divide one number from the other.
Dividing numbers in Google Sheets
In the example below you can see there is the number ‘100’ in cell A1 and we want to divide this number by ‘3’, which is the number in cell B1. Assuming you want to write the formula in cell C1.
The formula to divide numbers in Google Sheets:
- Select cell C1
- type the following formula =A1/B1
- Press return
Providing you’ve done this correctly the number you should see in cell C1 is 33.33333333. Google Sheets is returning this number because this is the exact number you would get when dividing 100 by 3.