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.

How to divide numbers in Google Sheets

The formula to divide numbers in Google Sheets:

  1. Select cell C1
  2. type the following formula =A1/B1
  3. 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.

You may also be interested in

How to subtract numbers in Google Sheets

How to add numbers in Google Sheets 

How to multiply numbers in Google Sheets

Chrome Computing for Chromebooks, Chrome OS and Android - Subscribe to the YouTube Channel
Chrome Computing
Logo