Use this formula instead.
Formula
=ARRAYFORMULA(IFERROR(A2:A/B2:B))
Note
Error catching has to take place inside the ARRAYFORMULA
Top answer 1 of 3
4
Use this formula instead.
Formula
=ARRAYFORMULA(IFERROR(A2:A/B2:B))
Note
Error catching has to take place inside the ARRAYFORMULA
2 of 3
3
Just for completeness:
In C2 you can write:
=A2/B2
then copy the cell (CTRL-C) and paste it (CTRL-V) to the whole column where you want the result to be visible. This will procude the same result as ARRAYFORMULA() and is in general more effort, but allows you to select the rows where you want to have the result.
Alternatively you can also provide the last row you want to calculate over to arrayformula.
=ARRAYFORMULA(A2:A27/B2:B27)
This would only print in lines 2-27.
Layer
golayer.io › home › how to divide in google sheets (easy guide)
How to Divide in Google Sheets (Easy Guide) | Layer Blog
November 12, 2024 - 1. Type the equal sign and select the column with the dividends. 2. Add the division symbol and select the common divisor. 3. Press Ctrl/Cmd + Shift + Enter to add the ARRAYFORMULA function.
I would like to split the cells underneath a column heading. How can I split a cell in sheets please - Google Docs Editors Community
Skip to main content · Google Docs Editors Help · Sign in · Google Help · Help Center · Community · Google Docs Editors · Terms of Service · Submit feedback · Send feedback on More on support.google.com
excel - Dividing whole column in Google Spreadsheet - Stack Overflow
I'm a relatively new user to Google Spreadsheet. I'd like every cell in the «B» column to be the result of what's in the «A» column (in the same row) but divided by 5. B1, B2, B3, etc. (the quoti... More on stackoverflow.com
how do you split cells in google sheet - Google Docs Editors Community
Skip to main content · Google Docs Editors Help · Sign in · Google Help · Help Center · Community · Google Docs Editors · Terms of Service · Submit feedback · Send feedback on More on support.google.com
How do I make Google Spreadsheet automatically divide a column into another column? - Stack Overflow
I'm making a spreadsheet that includes a long list of values, with a column that contains a total of values, and after that an average of the values in the row. I need the averaged column to always... More on stackoverflow.com
Simular
simular.ai › workflow › how-to-divide-in-google-sheets-a-practical-guide-today
How to Divide in Google Sheets, A Practical Guide Today
August 13, 2026 - Google Sheets will divide each value in column A by the value in the same row of column B and spill the results down automatically.
Google Support
support.google.com › docs › thread › 3886776 › i-would-like-to-split-the-cells-underneath-a-column-heading-how-can-i-split-a-cell-in-sheets-please
I would like to split the cells underneath a column heading. How can I split a cell in sheets please - Google Docs Editors Community
April 9, 2019 - Skip to main content · Google Docs Editors Help · Sign in · Google Help · Help Center · Community · Google Docs Editors · Terms of Service · Submit feedback · Send feedback on
Spreadsheet Point
spreadsheetpoint.com › home › google sheets tips › how to divide in google sheets (numbers, cells, or columns)
How to Divide in Google Sheets (Numbers, Cells, or Columns)
May 29, 2023 - So these are some of the ways you can divide sheet in Google Sheets. Based on whether you want to divide numbers, cells, or columns, you can choose to use the DIVIDE function or the divide operator.
Top answer 1 of 2
6
The word you are looking for is called cell reference in Excel or spreadsheet lingo.
Use the formula =DIVIDE($A1,5) and drag the cell handle down across all the cells. Here is my sample.
When I dragged the first cell to the end, this is what google spreadsheet did
Result with values
2 of 2
0
why not:
=INDEX(IFERROR(A1:A/5; 0)
Spreadsheet Class
spreadsheetclass.com › home › google sheets formulas › how to divide in google sheets (divide numbers, cells, columns, & rows)
How to divide in Google Sheets (Divide numbers, cells, columns, & rows)
October 28, 2023 - To divide entire columns with a single formula, follow these steps: Enter your division formula in a cell at the top of the column, like this: =A2/B2 · Press Ctrl + Shift + Enter on the keyboard to turn the division formula into an ARRAYFORMULA ...
Tech Junkie
techjunkie.com › web › google sheets
How to Divide One Column by Another in Google Sheets - Tech Junkie
September 4, 2020 - Let’s say that you have two columns with 10 numbers in each – we’ll call them column A and column B. You now want to divide column A by column B, and you’d like to get results in column C. Here’s what you have to do: Click on the cell C1.
Google Support
support.google.com › docs › thread › 213804647 › how-do-you-split-cells-in-google-sheet
how do you split cells in google sheet - Google Docs Editors Community
May 2, 2023 - Skip to main content · Google Docs Editors Help · Sign in · Google Help · Help Center · Community · Google Docs Editors · Terms of Service · Submit feedback · Send feedback on
Google Support
support.google.com › docs › answer › 6325535
Split text, remove duplicates, or trim whitespace - Computer - Google Docs Editors Help
You can split clearly defined data, like text separated by commas, into several columns with Google Sheets. For example, a column with "Last name, First name" can be split into 2 columns: "Last name" and "First name." On your computer, open a spreadsheet in Google Sheets. If the data’s already in the sheet, select the cells you want to split.
Stack Overflow
stackoverflow.com › questions › 65436355 › how-do-i-make-google-spreadsheet-automatically-divide-a-column-into-another-colu
How do I make Google Spreadsheet automatically divide a column into another column? - Stack Overflow
Enter =K2/6 in cell L2; then select cell L2 and drag/fill it down to L12. (That means click on the dot in the lower right corner of the cell and drag it down.) Or however far your sheet actually goes.
YouTube
youtube.com › shorts › 5bhF2Q_lPLo
How to Divide in Google Sheets - YouTube
In this short tutorial, I show how to divide in Google Sheets#googlesheets #googlesheetstips #googlesheetstutorial #spreadsheets #spreadsheetips #spreadsheet...
Published: August 9, 2024
ExcelMojo
excelmojo.com › home › google sheets › google sheets math functions › divide in google sheets
Divide In Google Sheets - Divide Columns, How To Divide?
February 4, 2025 - So, in this example, it is =QUOTIENT(A2:A6,B2:B6). Step 3: Press Enter key. We can see the result as shown in the below image. Likewise, we can use divide function in Google sheets to divide columns in Google sheets.
Hands-On Data Visualization
handsondataviz.org › split-data.html
Split Data into Separate Columns | Hands-On Data Visualization
Select the column and go to Data > Split text to columns to start splitting from left to right. Google Sheets will automatically split your cell into two parts, 300 Summit St and Hartford CT--06106, using comma as a separator.
YouTube
youtube.com › shorts › tjvtMV2eQLM
Split Columns in Google Sheets (The Easy Way) - YouTube
Splitting columns in Google Sheets is easy with the “text to columns” feature. It can separate a single column (like a full name) into multiple columns usin...
Published: May 4, 2026
Owox
owox.com › blog › articles › google sheets tips › how to split cells in google sheets: a step-by-step guide
How to SPLIT Cells in Google Sheets: A Step-by-Step Guide
May 14, 2026 - In datasets where date and time values are combined into a single cell, separating them into distinct columns can simplify analysis and improve readability. Using the SPLIT function in Google Sheets, you can easily divide these values based on the space delimiter between the date and time components.
SimpleSheets
simplesheets.co › blog › how-to-divide-in-google-sheets
How To Divide in Google Sheets
July 11, 2024 - Now, type the division formula. Start typing the equal sign "=" to let Google Sheets know you're entering a formula. Then, enter the number to be divided, separated by the divide operator "/." For example, to divide 72 by 13, you would type =72/13.
Google Workspace
workspace.google.com › marketplace › app › split_sheet › 259091386184
Split Sheet - Google Workspace Marketplace
July 9, 2026 - Split Google sheet into multiple sheets by columns or rows. ... Ever wondered how to separate a huge dataset in Google Sheets into smaller groups the easy way? Split Sheet is your formula-free answer! There are only 3 SIMPLE SETTINGS: 1. SELECT SHEET – SIZE DOESN'T MATTER No matter how big your table is, the tool will divide your Google sheet without any formulas.
Excel Insider
excelinsider.com › home › google sheets › how to split cells in google sheets
How to Split Cells in Google Sheets - Excel Insider
October 31, 2025 - However, by using cell formatting, ... selected cells according to the selected separator, pick the full column or range of cells, then click Data > Split Text to Columns....
YouTube
youtube.com › george kao
splitting one column into multiple columns in google spreadsheet - YouTube
More info directly from Google: https://support.google.com/docs/answer/6325535?co=GENIE.Platform=Desktop&hl=en
Published: June 11, 2019
Views: 10K