How to divide numbers in Google Sheets

Dan Millward January 11, 2019

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.