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.
Steps
-
1
Enter =A1/B1.
-
2
Protect against #DIV/0! with IFERROR if needed.
-
3
Format the output.
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 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 →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.
Get the answer →How to use sparkline in Google Sheets
For use sparkline in Google Sheets, start from the cell or range you care about, then use the menu that matches the job (Format, Data, Insert, or View). Prefer a small test range before changing a whole tab. Search the menus for “use sparkline” if you are unsure which command applies. Linked glossary terms and formula pages below go deeper when this is function-related.
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.