Formulas > =DIVIDE()

How to Use DIVIDE() in Google Sheets

Description

Returns one number divided by another. Equivalent to the `/` operator.

How To Actually Use DIVIDE() in Sheets

DIVIDE(dividend, divisor)

Try DIVIDE yourself

In cells C1:C10, use the DIVIDE function to divide the values in column A (A1:A10) by the values in column B (B1:B10). The correct answer should return the quotient of each division.

Hints (2)

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas

Learn more about the DIVIDE() formula:

Generate a DIVIDE() formula for your needs

Describe your task in plain English and get a paste-ready formula that uses DIVIDE(). 2 free AI generations, no signup. Members get unlimited use.

Generate a DIVIDE() formula