Home Web AppsGoogle Sheets How to divide numbers in Google Sheets

How to divide numbers in Google Sheets

by Dan Millward
How to divide numbers in Google Sheets

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

Related Articles