Here’s how to divide in Google Sheets.
This example uses cell D1.
SelectFunctions>Operator>DIVIDE.
Alternatively, go to theInserttab to find functions.
Choose adividendand adivisorfor 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.
The divisor cannot equal 0.
PressEnterto complete the formula.
The formula result appears in the cell.
In this example, the number2is in cell D1, since 20 divided by 10 equals 2.
There are two ways to enter data when creating a formula in Google Sheets.
you’ve got the option to enter numbers directly, for example,=DIVIDE(20,10).
Usingcell referencesrather 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 fault signal 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.
To do that, highlight the cell and selectFormat>Number>Percent.
The 0.3333333333 changes to 33.33%.
