Dividing numbers in google sheets is one of the most common use cases for spreadsheet users. In this article we show you exactly how to divide in google sheets using the divide operator and the DIVIDE function.
The divide operator or the slash symbol (/) is used to divide two specified numbers. In google sheets, you can use this on individual numbers or by putting the operator between two cell references containing numbers.
In this The dividend is the whole you want to divide into a number of specified parts. Let us set this to be 100.
Your divisor is the specified number of parts you will be dividing your dividend into. Here we want 100 to be divided into 5 parts.
Use the equal sign before the formula and remember to use the slash symbol in between the two values. You can input your dividend and divisor in several ways in Google Sheets:
As Direct Values
=100/5
As Cell References
=A2/B2
As Combination of Direct Values and Cell References
=A2/5
As Locked Cell References
=A2/$B$2
The addition of $ will lock the formula to the referenced cell. Even when you drag the formula to other spaces, the locked value will not change in Google Sheets. This is useful for dividing multiple numbers to the same number.
Google Sheets also has a function that we can use for dividing values called the DIVIDE Function. Here’s a quick look at its syntax and use.
=DIVIDE(dividend, divisor)
You can input the dividend and divisor as direct values or cell references when using the DIVIDE Function in Google Sheets. Here are the steps to use this function:
For this example let us use several numbers and get their percentages.
Now you can easily visualize your quotients as percentages and use these values for your needs.
If you enjoyed this article, you might also like our article on how to use standard deviation in Google Sheets or our article on how to calculate mean in Google Sheets.
If you want to learn how to use mail merge in Google Sheets, we also suggest checking out our detailed guide.
