DIVIDE in Google Sheets: Ratios, Unit Costs and Zero Divisors
Use DIVIDE in Google Sheets for full numeric ratios, unit costs and percentage comparisons, with zero-divisor handling and independent worked examples.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
Quick answer: =DIVIDE(175,8) has expected result 21.875. DIVIDE divides its first argument by its second, giving a full numeric ratio. It is the function form of the / operator.
Syntax and argument order
=DIVIDE(dividend, divisor)
The dividend is the amount being divided; the divisor is the amount by which it is divided. Both arguments are required. Google specifies that the divisor cannot be zero in its DIVIDE reference. No optional defaults are documented.
Argument order matters: total cost divided by units gives cost per unit; units divided by total cost gives units per currency unit. Label both source columns so the intended ratio is clear.
Worked example: purchase cost per unit
Enter the following table in A1:C4:
| Row | A: Delivery | B: Total cost | C: Units |
|---|---|---|---|
| 1 | Delivery | Total cost | Units |
| 2 | A | 175 | 8 |
| 3 | B | 90 | 6 |
| 4 | Sample | 0 | 5 |
In D1 enter Cost per unit. In D2 enter and fill down to D4:
=DIVIDE(B2,C2)
Expected results: 21.875, 15, 0. A zero numerator is mathematically valid when the divisor is nonzero. The zero-cost sample has a cost per unit of zero; it is different from a row with no units.
For a check, =B2/C2 has the same documented arithmetic meaning and expected result 21.875. For decimal quantities, =DIVIDE(87.5,2.5) has expected result 35. DIVIDE is not restricted to whole numbers.
DIVIDE, QUOTIENT and MOD answer different questions
For seven items split into groups of two:
=DIVIDE(7,2)
=QUOTIENT(7,2)
=MOD(7,2)
Expected results are 3.5, 3 and 1, respectively: full ratio, whole quotient and remainder for these positive inputs.
There is an inconsistent equivalence note on the DIVIDE help page. Its main definition identifies ordinary division, while Google’s QUOTIENT reference explicitly directs readers to DIVIDE or / for the full result. That function-specific distinction is the basis of this example; QUOTIENT is not treated as a general DIVIDE alias. These are independently derived expectations, not a native resolution of every edge case.
Advanced application: divide totals instead of averaging ratios
Use only the first two deliveries in the table:
=DIVIDE(SUM(B2:B3),SUM(C2:C3))
Expected result: 18.9285714286, from total cost 265 divided by 14 units. It is the combined unit cost.
By contrast, =AVERAGE(D2:D3) gives 18.4375, because it gives the two deliveries equal importance even though their unit counts differ. Choose the ratio of totals when each unit, rather than each delivery, should have equal weight.
For a separate target comparison, =DIVIDE(250,200) gives 1.25. A percent display shows 125%, meaning the actual amount is 125% of target. The amount above target is 25%, which is a different calculation, (250-200)/200.
A deliberate zero-divisor policy
To display a readable message for a row with zero units:
=IF(C2=0,"No units",DIVIDE(B2,C2))
For the original row, expected result 21.875. If C2 is changed to numeric zero, the intended result is the text No units. Restore C2 to 8 before continuing other examples.
The message is a reporting choice, not a numerical value. It should not be replaced with zero unless zero is genuinely the correct business meaning. Nor should a broad error handler conceal bad imports, incorrect references or unexpected error values.
Errors and troubleshooting
- Check for a zero divisor, including formulas whose computed result is zero.
- Confirm cost and quantity are numeric, in consistent units and aligned on the same row.
- If the answer looks rounded, show more decimal places before changing the formula.
- Check numerator/denominator order and local separators if a formula is rejected.
- Review a range-based calculation separately; the examples here use scalar values and scalar totals, not an asserted array-broadcast contract.
The reviewed DIVIDE help gives the zero-divisor restriction but does not enumerate a full native error-token, blank-cell or text-coercion matrix. No untested token mapping is imported from another spreadsheet engine.
Availability and verification
DIVIDE is documented in the current rolling Google Sheets service. Original introduction date, introduction version and last functioning numbered release were not established. When moving formulas to another application, verify the named function or use that application’s documented division syntax with the same inputs.
NOT_TESTED_IN_GOOGLE_SHEETS. The individual DIVIDE and QUOTIENT documentation was inspected on October 17, 2026. All numerical examples were calculated independently with decimal or rational arithmetic. No native Sheets session or screenshot was used.