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.
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 Add Columns in Google Sheets
How to Merge Cells in Google Sheets
How to make a Pill Form Field in Google Sheets
3 Free Tools to Make Your Google Sheets Better
Google Sheet Basics - The Absolute Basics
Related blog posts
Written guides that go deeper on this question.
4 Ways to Resize Columns, Change the Column Width in a Google Sheet
Adjusting column width is crucial for enhancing the readability and functionality of spreadsheets. Properly sized columns ensure that all data is visible without unnecessary scrolling or cutting off information, which can lead to errors or misinterpretations.
Read post →How To Add Columns in Google Sheets
How to add columns in google sheets, in 7 different ways.
Read post →10 Simple Ways to Make Your Spreadsheets Better
Here's a few things you can do very simply and in no time at all, to make your spreadsheets better. Make better spreadsheets for you to spend time in. And better for other people who have to use your spreadsheets.
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 →COLUMNS()
Google Sheets COLUMNS() function guide
Open →DIVIDE()
Google Sheets DIVIDE() function guide
Open →IFERROR()
Google Sheets IFERROR() function guide
Open →Related questions
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 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 →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.