How to use divide function in Google Sheets
Divide with =A1/B1 or =DIVIDE(A1, B1). Wrap with IFERROR(...,0) if divisors can be blank or zero. Format the result as a number or percent as needed.
Steps
-
1
Enter =A1/B1.
-
2
Protect against #DIV/0! with IFERROR if needed.
-
3
Format the output.
Related tutorials
These videos might help you go deeper on this topic.
Related blog posts
Written guides that go deeper on this question.
Better Sheets on YouTube
Watch matching videos from youtube.com/bettersheets.
Terms and formulas behind this
Want the full definition or how a formula works? Start here.
Wrap text
Wrap text displays cell content on multiple lines within the same cell instead of spilling into neighbors. Format > T...
Open →protect sheets/ranges
Protection limits who can edit specific cells, ranges, or entire tabs while others keep view or comment access. It is...
Open →cell formatting
Cell formatting controls how values display without necessarily changing the stored value underneath. Currency, perce...
Open →Formula errors in Google Sheets
Formula errors are typed messages in cells when something prevents a valid result. Each code points to a different fa...
Open →#DIV/0! error
#DIV/0! appears when a formula divides by zero or by an empty cell treated as zero. It is common in conversion rate, ...
Open →IFERROR
IFERROR wraps another formula and returns value_if_error when the inner expression hits any error, including #N/A, #R...
Open →DIVIDE()
Google Sheets DIVIDE() function guide
Open →IFERROR()
Google Sheets IFERROR() function guide
Open →Related questions
How to divide a column in Google Sheets
Divide with =A1/B1 or =DIVIDE(A1, B1). Wrap with IFERROR(...,0) if divisors can be blank or zero. Format the result as a number or percent as needed.
Get the answer →How to divide in Google Sheets
Divide with =A1/B1 or =DIVIDE(A1, B1). Wrap with IFERROR(...,0) if divisors can be blank or zero. Format the result as a number or percent as needed.
Get the answer →How to divide on Google Sheets
Divide with =A1/B1 or =DIVIDE(A1, B1). Wrap with IFERROR(...,0) if divisors can be blank or zero. Format the result as a number or percent as needed.
Get the answer →How to divide two columns in Google Sheets
Divide with =A1/B1 or =DIVIDE(A1, B1). Wrap with IFERROR(...,0) if divisors can be blank or zero. Format the result as a number or percent as needed.
Get the answer →How to divide a column by a number in Google Sheets
Divide with =A1/B1 or =DIVIDE(A1, B1). Wrap with IFERROR(...,0) if divisors can be blank or zero. Format the result as a number or percent as needed.
Get the answer →Need more than a quick answer?
600+ walkthrough videos, unlimited generators, and every template. From $9/month. Practical lessons. Zero fluff.
Need one fix
Watch a free tutorial for the step-by-step version of any answer.
Learning Sheets for real
Unlock the full library, generators, and templates with membership.