How to divide 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.
How to Merge Cells in Google Sheets
3 Free Tools to Make Your Google Sheets Better
How To Duplicate a Tab and Move it to the End in Google Sheets
How To Add Columns in Google Sheets
Related blog posts
Written guides that go deeper on this question.
What's Better Than Google Sheets?
Nothing is better than Google Sheets. You just need to learn more about the unlimited power of Google Sheets. Functions, Formulas, Apps Script and more.
Read post →Extract URLs from Google Sheets
Extract url from hyperlink google sheets.Skip the Command K. This Google Sheet tutorial will make it easier for you to extract URLS from Google Sheets.
Read post →Getting Started in Google Sheets Spreadsheet Management
Users can also customize the appearance of their spreadsheets with different fonts, colors, and themes.
Read post →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 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 cells 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 cell 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 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 →Need more than a quick answer?
637+ 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.