How to divide numbers in google sheets

Brady Gavin
How to divide numbers in google sheetsBrady Gavin
Writer

Brady Gavin has been immersed in technology for 15 years and has written over 150 detailed tutorials and explainers. He’s covered everything from Windows 10 registry hacks to Chrome browser tips. Brady has a diploma in Computer Science from Camosun College in Victoria, BC. Read more.

How to divide numbers in google sheets

Whether you need to divide static integers or data from two cells or the entire contents of two columns, Google Sheets provides a couple of methods to help you calculate the quotient. Here’s how.

Using the DIVIDE Formula

Fire up your browser, head to Google Sheets, and open a spreadsheet.

Click on an empty cell and type =DIVIDE(,) into the cell or the formula entry field, replacing and with the two numbers you want to divide.

Note: The dividend is the number to be divided, and the divisor is the number to divide by.

How to divide numbers in google sheets,)” into the cell, replacing and with the two numbers you want to divide. ” width=”413″ height=”289″ />

You can also use the data inside another cell. Instead of a number, type the cell number and Sheets will automatically put the integer from that cell in its place.

How to divide numbers in google sheets

After you input the numbers or cell numbers, press the “Enter” key and Sheets will place the results in the cell.

How to divide numbers in google sheets

Using the Divide Operand

This method uses the Divide operand (/) to find the product of some numbers. The only difference is if you have more than two numbers, you’re able to input as many as you want, whereas the previous formula is limited to two.

From your Google Sheets spreadsheet, click an empty cell and type =/ into the cell or the formula entry field, replacing and with the two numbers you want to divide.

How to divide numbers in google sheets / ” replacing and with the numbers you want.” width=”413″ height=”265″ />

Just like before, you can reference other cells inside the spreadsheet. Replace either number with the number of a cell that contains a number in it.

How to divide numbers in google sheets

After you input the numbers or cell numbers, press the “Enter” key and Sheets will place the results in the cell.

How to divide numbers in google sheets

If you’re working with a table and want to divide the data from Rows 1 and 2 into Row 3, Google Sheets has a neat feature that applies the formula to the rest of the cells in Row 3. It fills in the remaining cells with the formula and the results.

Double-click the little blue square, and, like magic, the rest of the table is filled in with the product of the two numbers. This feature can be used with either formula, but it works only when using cell references.

How to divide numbers in google sheets

  • › How to Show Your Work Hours and Location in Google Calendar
  • › You Can Finally Move WhatsApp Chats From iPhone to Android
  • › How to Print Double-Sided on Windows 11
  • › Samsung Galaxy Phones Are Getting Grammarly Installed by Default
  • › How to Enable Cookies in Google Chrome

How to divide numbers in google sheets Brady Gavin
Brady Gavin has been immersed in technology for 15 years and has written over 150 detailed tutorials and explainers. He’s covered everything from Windows 10 registry hacks to Chrome browser tips. Brady has a diploma in Computer Science from Camosun College in Victoria, BC.
Read Full Bio »

Key Difference – Google Docs vs Google Sheets

The key difference between Google Docs and Google Sheets is that Google Docs is a document management applications whereas Google Sheets is an application used to formulate and manipulate data within Google Docs. Google sheet is an application that belongs to Google docs. It is important to know the difference between Google docs and Google sheets. Let us take a closer look at both the Google products and see what they have to offer.

Google Docs – Features and Specifications

Google docs is a document management application that is web based. It is used to create and edit private and public spreadsheets and word processing documents. The edited and created documents can be saved online on Google cloud or on your personal computer. Google Docs can be accessed via a full featured browser and a computer with an internet connection. The document can be viewed by members and google groups with the permission of the owner.

Google docs has been specially designed for individual and real-time collaborative projects. The security of the document is maintained online and on the user’s computer. However, some of the users are concerned regarding security as online documents can be viewed copied or stolen by others.

The documents created on Google docs are usually supported by and compatible with most presentation and word processing applications. These documents can also be printed and published as a web page. Various fonts and file formats can be used to edit spreadsheets.

Google releases new features for Google docs on a regular basis. There is also an online help group to answer questions and fix related problems that we may run into.

Google docs system requirements are very simple and only requires a web browser. Google docs is compatible with many of the browsers available today. But, you need a Google account to access google docs. Google account is free. You will only need an email address and to agree to the terms and conditions put forward by Google to create a Google account. If you have ever signed up for Gmail, you will already have a google account. The account will give you access to many other application other than Google docs.

The user can create new spreadsheets, presentations, and documents or upload an existing file onto the system. Google docs is compatible with the following file formats.

File Formats Compatible with Google Docs

  • Comma Separated Value files or .csv
  • Microsoft Word, PowerPoint, and Excel (.doc, .ppt, . pps and .xls)
  • Rich text format (.rtf)
  • Hypertext markup language (HTML)
  • OpenDocument Text and Spreadsheet formats *(.odt and .ods)
  • Text files (.txt)
  • Star Office documents ( .sxw)

You will become the owner of the file you created or import to Google docs. Owners have the power to create and delete files and invite viewers and collaborators. Collaborates can export and edit files. The owner can choose other collaborators to join the project via the existing collaborators. Viewers can export and view files but are not allowed to edit them.

Google docs use a simple file and folder system as its organizational approach. You are able to create folders and subfolders for all of your files. You can use sort in multiple modes to sort all of your data.

Google docs provide you with a lot of space, but it is not unlimited.

Each account can have

  • 5000 documents of 500 kb each
  • 1000 spreadsheets of 1Mb each
  • 5000 presentations of 10 MB each

You will also be able to search inside Google docs.

How to divide numbers in google sheets

Figure 01: Google Docs

Google Sheets – Features and Specifications

Gone are the days when you needed to spend a lot of money to buy a solid spreadsheet program. Today Google spreadsheet is available within your local Google account. You can log onto your google account, create a spreadsheet and you are ready to go.

Google spreadsheets is a web-based application that will allow users to create, modify and update spreadsheets. The data used for the spreadsheets can be shared live online. This application is compatible with Microsoft Excel, and comma separated values. The spreadsheets can also be saved in HTML format.

The application comes with typical spreadsheet features. Data can be added, deleted and sorted in rows and columns. Multiple, geographically dispersed users can collaborate on the spreadsheet via real time. Google spreadsheet has a real time built in messaging program for communication. The user has the ability to upload spreadsheets directly from their computers as well.

Google spreadsheets come with keyboard shortcuts that will help you work more efficiently. Google spreadsheet also comes with forms which help in completing surveys from customers. You can view other team members who are viewing the same document. Google spreadsheet allows you to chat and collaborate with team members in real time. As with Microsoft excel, there are formulas that can help you complete your work with ease.

How to divide numbers in google sheets

Figure 02: Google Sheets

What is the difference between Google Docs and Google Sheets?

Google Docs vs Google Sheets

Summary – Google Docs vs Google Sheet

It is clear that Google Docs and Google sheet are clearly two different tools. As a document management application, Google Docs is one of the best to date, and Google sheets is able to accomplish many of the functions done in a similar proprietary application. The main difference between Google Docs and Google sheets is their purpose and function.

Image Courtesy:
1. “Google Docs: Kudos Hamish Laing @LaingHamish and Ryan Mearns @ryanmearns for transcribing #COP21 ADP Sessions” by Ron Mader (CC BY-SA 2.0) via Flickr
2. “How to Color Alternate Rows in Google Sheets” by Amit Agarwal (CC BY 2.0) via Flickr

Google Sheets is now the go-to spreadsheet tool for most people. It’s free, super easy to collaborate with, and has some pretty awesome functions and features.

Even if you want to do something as basic as data record-keeping or simple calculations such as multiplication or division, you can easily do that in Google Sheets.

In this tutorial. I will show you a couple of ways to divide numbers in Google Sheets.

You can easily divide numbers in Google Sheets using an inbuilt formula or using the divide operator (as we will see with examples).

So let’s get started!

Table of Contents

Divide Two Cells In Google Sheets

If you want to divide two numbers in Google Sheets (or two cells that have the numbers), then there are a couple of ways to do this in Google Sheets.

Using the DIVIDE function

Doing a division in Google Sheets is such a regular task that there is an in-built function that allows you to divide two numbers or numbers that are in two cells.

It’s the DIVIDE function (no marks for guessing)!

Suppose you want to divide the value in cell A1 with the value in cell B1.

You can use the below DIVIDE formula to do this:

In the above formula, the first argument is the dividend (the number which has to be divided) and the divisor (the number with which to divide)

I have used the cell references in the above example, but you can also hard-code values into the formula. For example, you can also use the below formula:

The benefit of using cell references is that your formula result becomes dynamic. This means that in case I change the value in cell A1 or B1, the formula would automatically update.

Also, remember that the divisor can not 0. In case your divisor is 0, you will get the division error – #DIV/0!

Using the DIVIDE Operator

Another quick way to divide numbers in Google Sheets is by using the divide operator – the forward-slash (/)

Suppose you have the data as shown below and you want to divide the value in cell A1 with the value in cell B1.

You can use the below equation to do this:

And in case you want to quickly divide numbers (instead of cell references), you can do that as well (as shown in the below formula):

Order of Precedence when Dividing Cells

An important thing to know when using arithmetic operators (such as division or multiplication) in Google Sheets is the order of precedence.

Let me try and explain this with an example.

Suppose I use the below formula:

Can you guess what the result would be?

How to divide numbers in google sheets

This happens as there is an order of precedence in Google Sheets where division is done before addition. Hence it first divides 1200 by 15 where the result is 80. It then adds 15 to this result giving you the overall result as 95.

Now, it’s not difficult to figure this out in our simple example, but this can lead to issues when working with large complex formulas.

In such cases, it’s best to not worry about the order of precedence by keeping calculations in brackets (parenthesis).

For example, in case you want to first do the addition and then the division, you can use the below formula:

This will give you the result as 40 (=1200/30)

How to divide numbers in google sheets

Dividing Two Columns In Google Sheets

In real-life scenarios, you wouldn’t want to open Google Sheets for a simple division. You can easily do that using calculator on your smartphone or with a simple Google Search.

Where you can use Google Sheets is to quickly divide numbers into columns and get the result for hundreds of cells in a second.

For example, suppose you have the dataset as shown below and you want to calculate the division when the value in column A is divided by the corresponding cell in column B

How to divide numbers in google sheets

Below is the formula that will do this:

How to divide numbers in google sheets

Since this is an array formula, you only need to enter this formula in cell C1 only and it will give you the result as shown above.

Also, you can not delete or edit a part of the array. You can, however, delete the entire array by deleting the content in cell C1.

Divide without Remainder in Google Sheets

Let’s say you have the dataset as shown below and you want to divide the value in column A with that of in column B.

How to divide numbers in google sheets

If you do it as shown in the previous section, you would get the integer part as well as the decimal part.

In case you don’t want any remainder when these values are divided (where the remainder is the decimal part), you can use the below formula:

How to divide numbers in google sheets

The above formula uses the same division formula but wraps it within an INT function, which will only return the integer part of the result and not the decimal part.

So these are some of the ways you can divide in Google Sheets. Based on whether you want to divide numbers, cells, or columns, you can choose to use the DIVIDE function or the divide operator.

Whether you need to divide static integers or data from two cells or the entire contents of two columns, Google Sheets provides a couple of methods to help you calculate the quotient. Here’s how.

Click on an empty cell and type =DIVIDE(←dividend→,←divisor→) into the cell or the formula entry field, replacing ←dividend→ and ←divisor→with the two numbers you want to divide.

You can also use the data inside another cell. Instead of a number, type the cell number and Sheets will automatically put the integer from that cell in its place.

After you input the numbers or cell numbers, press the “Enter” key and Sheets will place the results in the cell.

This method uses the Divide operand (/) to find the product of some numbers. The only difference is if you have more than two numbers, you’re able to input as many as you want, whereas the previous formula is limited to two.

From your Google Sheets spreadsheet, click an empty cell and type =←dividend→/←divisor→ into the cell or the formula entry field, replacing ←dividend→ and ←divisor→ with the two numbers you want to divide.

Just like before, you can reference other cells inside the spreadsheet. Replace either number with the number of a cell that contains a number in it.

If you’re working with a table and want to divide the data from Rows 1 and 2 into Row 3, Google Sheets has a neat feature that applies the formula to the rest of the cells in Row 3. It fills in the remaining cells with the formula and the results.

Double-click the little blue square, and, like magic, the rest of the table is filled in with the product of the two numbers. This feature can be used with either formula, but it works only when using cell references.

How to divide numbers in google sheets

If you want to split integers or data from two cells or two columns, you can do this on Google Sheets, not just one way. And here’s how.

Using the DIVIDE . formula

Open a browser, go to Google Sheets and open the spreadsheet.

Click in the empty box and type =DIVIDE(

Note: Dividend is the divisor and divisor is the divisor.

How to divide numbers in google sheets

You can also use data in other cells. Instead of a number, type a cell number and Sheets will automatically put the integer from that cell in its place.

How to divide numbers in google sheets

After entering the number or cell number, press Enter and Sheets will display the results in the cell.

How to divide numbers in google sheets

Using the division operand

This method uses the Divide (/) operand to find the result of several numbers. The only difference is that if there are more than two numbers, you can enter as many as you want while the previous formula is limited to two.

From a Google Sheets spreadsheet, click in an empty cell and type

How to divide numbers in google sheets

Like before, you can reference other cells in the spreadsheet. Replace the number with the number of cells with the number in it.

How to divide numbers in google sheets

After entering the number or cell number, press the . key Enter and Sheets will calculate the result.

How to divide numbers in google sheets

If you work with tables and want to split the data from rows 1 and 2 into rows 3, Google Sheets has a feature that can apply formulas to the remaining cells in row 3, which is very handy. It will fill the remaining cells with the formula and result.

Double click on the little blue square and the rest of the table will be populated with the results. This feature can be used for the above formula, but it only works when using cell references.

Division is one of the most basic operations we have learned growing up. To most people, division is quite difficult. Thanks to Excel, division can now be performed with ease and accuracy.

How to divide in?

Division in Excel is easily done by using the forward slash “/”, which is the division symbol.

Suppose we want to divide any number ( a) by another number ( b) . The divide formula is

=a/b

where a is the dividend and b is the divisor.

How to divide numbers in google sheets How to divide numbers in google sheets How to divide numbers in google sheets How to divide numbers in google sheetsHow to divide numbers in google sheetsFigure 1. divide formula

How to divide two numbers?

Dividing is very straightforward. We enter the equal “=” sign to activate the formula function, then the numerator, followed by the forward slash “/” followed by the denominator.

When we want to divide 8 by 2, the formula to use is:

where 8 is the numerator or dividend and 2 is the denominator or divisor.

Figure 2. Divide numbers

How to divide two cells in?

The formula to divide cells uses the cell references containing the values as the numerator and denominator.

When we want to divide cell B3 by cell C3, we enter the formula:

Figure 3. Formula to divide two cells

How to divide a column by a number?

We can also divide a column by a number. When we want to divide column B by the number 2, we enter the formula

Where the numerator is a cell reference and the denominator is a number.

Figure 4. Divide a column by a number in Excel

How to divide columns and Google sheets?

Divide columns

It is possible to perform division in several columns in as little time as possible. In order to divide columns, we follow these steps:

  • Enter the formula in cell E3: =B3/C3
  • Press ENTER
  • Copy the formula in cell E3 by pressing Ctrl + C , then select cells E4 and E5 and press Ctrl + V to paste the formula

Figure 5. Divide columns

As a result, the values in column B are divided by the corresponding values in column C.

Divide columns in Google sheets

The formula to divide columns in Google sheets is similar to Excel. We simply use the cell references as the numerator and denominator in our division formula.

Figure 6. Divide columns in Google sheets

Is there a divide function?

Simply put, there is no function for the division operation. In order to divide, , we have to use the division symbol in a formula.

There is, however, the QUOTIENT function which returns only the integer portion of any division, excluding the remainder.

= QUOTIENT ( numerator , denominator )

  • Numerator – the dividend
  • Denominator – the divisor

We want to divide 10 by 3. Using the QUOTIENT function, we enter the formula

= QUOTIENT ( 10 , 3 )

Figure 7. QUOTIENT function

The QUOTIENT function does not consider the remainder of the division operation. Dividing 10 by 3 results to 3 with a remainder of 1. However, the QUOTIENT function only returns the integer part of the result, which is “3”.

Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.

How to divide numbers in google sheets

Spreadsheets have become the go-to solution for storing and handling data. And spreadsheets are not limited to numbers — they provide all the tools you need to manage text-based data as well. In this article, you’ll learn about the SPLIT function in Google Sheets. It helps you separate a text string based on a delimiter.

This means you can divide text (that’s currently in one cell) into separate columns. Imagine that you have a list of contacts in your spreadsheet. Each cell contains the contact’s first name and surname and you want to divide this into two separate columns: first name and last name. The SPLIT function is the solution.

Here’s how it works:

Syntax

=SPLIT( text, delimiter, [split_by_each], [remove_empty_text] )

  • text – the text or string that you want to split.
  • delimiter – a single character or a group of characters that the function should consider for splitting the text. By default, each character within the delimiter is considered individually. For instance, if the delimiter is “one”, then the text is divided around the characters “o”, “n”, and “e”. If you do not want this behavior, you can set the split_by_each to FALSE. Note that the delimiter will not be included in the output of the function.
  • split_by_each – [ OPTIONAL – TRUE by default ] – if you go with the default option, then the function considers each character within the delimiter string to split the text. If you set this to FALSE, then the function considers the delimiter as a whole. You can select this parameter by writing TRUE or FALSE, or by indicating 1 or 0, respectively.
  • remove_empty_text – [ OPTIONAL – TRUE by default ] – this parameter indicates whether or not the function should remove empty text fragments from the split results. The default behavior is to treat consecutive delimiters as one (if TRUE). If FALSE, empty cell values are added between consecutive delimiters. You can select this parameter by writing TRUE or FALSE, or by indicating 1 or 0, respectively.

How to use the SPLIT function in Google Sheets

The syntax looks a lot more complex than it actually is.

So, to get you comfortable with the function, I’ll show you some examples. Take a look at the screenshot below.

How to divide numbers in google sheets

You can see that the results that I get are the input text, broken into pieces at the points where the delimiters are in the text. For the first example, the delimiter is “e”, so the result is one cell with all the text before the e’s in “Sheetgo”, and one cell with all the text after the e’s. I achieve that here by typing =Split(A2,B2).

The same is true with the other examples shown. In each, I specify a delimiter, and the function breaks the text into chunks that come before, in between, and after the delimiters. This can be extremely convenient for separating text data such as first and last names separated by a comma, as seen in the third example above.

Tip: Leave empty columns to the right

I have entered all the functions in column D. That’s because the SPLIT function in Google Sheets spreads its output across multiple cells towards the right, as is the case with all the examples. So, it is very important that you keep the cells, where you expect the data to flow, clear of any values. Otherwise, the function returns a #REF! error.

These first few examples show the SPLIT function in its most basic form. I didn’t specify the optional parameters, so they remained at their default value. Now I’ll demonstrate what happens when you add in the optional parameters split_by_each and remove_empty_text.

SPLIT function with split_by_each parameter

The split_by_each parameter is used when the delimiter is more than one character long. As you can see in the image below, changing this parameter can have a significant impact on the output of the function.

How to divide numbers in google sheets

In this example, I am splitting the word “Countries” using the delimiter “one”.

The default value of the split_by_each parameter is 1 (TRUE), which tells the function to consider each character in the delimiter. So when you use this option, the function uses the “o”, “n”, and “e” as individual delimiters. You can see the result above: the text “Countries” is split into four parts.

The next example uses a split_by_each parameter value of 0 (FALSE), which tells the function to consider the delimiter text as one single delimiter of multiple characters. So in this case, the function will only split the text based on the delimiter of the entire word “one”. Of course, “one” does not appear in “Countries”, so it does not split the text at all. This goes to show the large difference in results that occurs when you change the split_by_each parameter when using a multi-character delimiter.

SPLIT function with remove_empty_text parameter

Now I’ll show an example using the remove_empty_text parameter. This parameter is used when you have consecutive delimiters in your text.

If the parameter is TRUE (default value) it will treat consecutive delimiters as a single delimiter; if FALSE, it will treat them as individual delimiters and add blank cells to the results.

How to divide numbers in google sheets

You can see the difference here. I have a text string that contains consecutive delimiters — in this case, two commas beside each other.

In the default case, where the remove_empty_text parameter is 1 (TRUE), the function treats the consecutive commas as one and outputs the text split up as expected.

In the second case, however, I’ve set the remove_empty_text parameter to 0 (FALSE). Now, the function treats each comma as a separate delimiter, so it adds a blank cell to the output to reflect the “space” (even though there is no space character) in between the two commas.

SPLIT function: Things to remember

There are a few things to keep in mind when using the SPLIT function. First, always make sure you have enough blank cells to the right since the SPLIT function can output across multiple cells.

Second, remember that the delimiter will always be removed from the text. For example, if you want to separate text strings by commas, the comma will not appear in any of the output cells.

Lastly, you can also split text by selecting Data > Split text to columns. This method is less versatile, however, so you may be better off using the SPLIT function – play around with both options to see for yourself!

Editor’s note: This is a revised version of a previous post that has been updated for accuracy and comprehensiveness.

Multiplying and dividing in Excel is easy, but you need to create a simple formula to do it. Just remember that all formulas in Excel begin with an equal sign (=), and you can use the formula bar to create them.

Multiply numbers

Let’s say you want to figure out how much bottled water that you need for a customer conference (total attendees × 4 days × 3 bottles per day) or the reimbursement travel cost for a business trip (total miles × 0.46). There are several ways to multiply numbers.

Multiply numbers in a cell

To do this task, use the * (asterisk) arithmetic operator.

For example, if you type =5*10 in a cell, the cell displays the result, 50.

Multiply a column of numbers by a constant number

Suppose you want to multiply each cell in a column of seven numbers by a number that is contained in another cell. In this example, the number you want to multiply by is 3, contained in cell C2.

Type =A2*$B$2 in a new column in your spreadsheet (the above example uses column D). Be sure to include a $ symbol before B and before 2 in the formula, and press ENTER.

Note: Using $ symbols tells Excel that the reference to B2 is “absolute,” which means that when you copy the formula to another cell, the reference will always be to cell B2. If you didn’t use $ symbols in the formula and you dragged the formula down to cell B3, Excel would change the formula to =A3*C3, which wouldn’t work, because there is no value in B3.

Drag the formula down to the other cells in the column.

Note: In Excel 2016 for Windows, the cells are populated automatically.

Multiply numbers in different cells by using a formula

You can use the PRODUCT function to multiply numbers, cells, and ranges.

How to divide numbers in google sheets

You can use any combination of up to 255 numbers or cell references in the PRODUCT function. For example, the formula =PRODUCT(A2,A4:A15,12,E3:E5,150,G4,H4:J6) multiplies two single cells (A2 and G4), two numbers (12 and 150), and three ranges (A4:A15, E3:E5, and H4:J6).

Divide numbers

Let’s say you want to find out how many person hours it took to finish a project (total project hours ÷ total people on project) or the actual miles per gallon rate for your recent cross-country trip (total miles ÷ total gallons). There are several ways to divide numbers.

Divide numbers in a cell

To do this task, use the / (forward slash) arithmetic operator.

For example, if you type =10/5 in a cell, the cell displays 2.

Important: Be sure to type an equal sign (=) in the cell before you type the numbers and the / operator; otherwise, Excel will interpret what you type as a date. For example, if you type 7/30, Excel may display 30-Jul in the cell. Or, if you type 12/36, Excel will first convert that value to 12/1/1936 and display 1-Dec in the cell.

Note: There is no DIVIDE function in Excel.

Divide numbers by using cell references

Instead of typing numbers directly in a formula, you can use cell references, such as A2 and A3, to refer to the numbers that you want to divide and divide by.

The example may be easier to understand if you copy it to a blank worksheet.

How to copy an example

Create a blank workbook or worksheet.

Select the example in the Help topic.

Note: Do not select the row or column headers.

Selecting an example from Help

In the worksheet, select cell A1, and press CTRL+V.

To switch between viewing the results and viewing the formulas that return the results, press CTRL+` (grave accent), or on the Formulas tab, click the Show Formulas button.

The Quotient function in Google Sheets is categorized under Math. There is a chance to confuse this math function with another math function DIVIDE.

Both the function DIVIDE and QUOTIENT can be used to divide numeric values. But where the differences lie? Let me explain that below.

QUOTIENT Vs DIVIDE:

As the name denotes, the Quotient function returns the quotient after dividing numeric values. To get the quotient and remainder, use the function DIVIDE.

Even though I have explained the DIVIDE function earlier, I think it’s wise to start this tutorial with this function as it’s more common in use.

The DIVIDE function is equal to the forward slash / arithmetic operator. Before jumping into the function syntax and formula example of Quotient, here is one example using the function Divide.

This formula would return 4.5 similar to the formula using the said arithmetic operator as follows – =9/2 .

Let’s begin with the Quotient function syntax and then we can compare it with the above formula. Here we go!

Quotient Function Syntax, Purpose and Examples in Google Sheets

Syntax:

Both the functions Divide and Quotient share the same argument.

dividend – It is the number to be divided.

divisor – It is the number to divide by (cannot equal 0).

Purpose of the Quotient Function in Google Sheets:

I have already explained the purpose between the lines above. Again just for formalities 🙂

The purpose of the Quotient function in Google Sheets is to divide numeric values. The output will be without the remainder.

Formula Examples:

Output: 4 (it’s 4.5 when using Divide)

As a side note, you can use the INT function together with DIVIDE function to get the output similar to the QUOTIENT. Here is that formula.

How to divide numbers in google sheets

Google Sheets uses functions to create formulas for basic mathematical concepts like addition, multiplication, and division. Here’s how to divide in Google Sheets. You’ll learn how to create a division formula, use it for percentage results, and deal with errors you might experience.

What to Know About Formulas in Google Sheets

To divide two numbers in Google Sheets, you need to create a formula. Here are some important points to remember about Sheets formulas:

  • Formulas always begin with an equal sign ( = ).
  • The equal sign always goes in the cell where you want the answer to go.
  • The division operator is the forward-slash ( / ).
  • Complete the formula by pressing the Enter key on the keyboard.

How to Divide in Google Sheets

Here’s how to use the divide function in Google Sheets:

Choose the cell you want the formula to appear in. This example uses cell D1.

How to divide numbers in google sheets

Select Functions > Operator > DIVIDE.

Alternatively, go to the Insert tab to find functions.

How to divide numbers in google sheets

Choose a dividend and a divisor for the formula. This example uses A1 and B1 as the dividend and divisor, respectively.

The dividend is the number to be divided. The divisor is the number to divide by. The result is called the quotient.

How to divide numbers in google sheets

The divisor cannot equal 0.

Press Enter to complete the formula. The formula result appears in the cell. In this example, the number 2 is in cell D1, since 20 divided by 10 equals 2.

How to divide numbers in google sheets

There are two ways to enter data when creating a formula in Google Sheets. You can enter numbers directly, for example, =DIVIDE(20,10). However, it’s better to enter the data into worksheet cells and use the addresses or references of those cells in the formula, for example, =DIVIDE(A1,B1). Using cell references rather than the actual data makes it easier to edit information later if needed. The results of the formula update automatically.

#DIV/O! Formula Errors

Sometimes you may get an error message if the formula is entered incorrectly. The most common error associated with division operations is #DIV/O!. This displays when the divisor is equal to zero, which is not allowed in ordinary arithmetic.

The most likely reason for this error is an incorrect cell reference was entered into the formula. It could also be that the formula was copied to another location using the fill handle, which changed the cell references and resulted in the error.

How to Calculate Percentages With Division Formulas

When the results of a division operation are less than one, Google Sheets represents it as a decimal by default, as shown in row three of the below example, where:

  • The dividend is set to 7.
  • The divisor is set to 21.
  • The quotient is equal to 0.3333333333.

How to divide numbers in google sheets

You can change that result to a percentage by changing the formatting in the cell. To do that, highlight the cell and select Format > Number > Percent. The 0.3333333333 changes to 33.33%.