In Google Sheets, if you attempt to divide a value by zero you will receive #DIV/0! as a result.
You can use the following basic syntax to perform division while ignoring #DIV/0! values:
=IFERROR(A2/B2, "")
In this particular formula, we attempt to divide the value in cell A2 by the value in cell B2.
If B2 happens to be a zero, we simply return a blank as a result.
The following examples show how to use this syntax in practice.
Example: Ignore #DIV/0 When Using Division in Google Sheets
Suppose we attempt to divide the values in column A by the values in column B in this particular Google Sheets spreadsheet:
Notice that for each cell in column C where we attempt to divide by zero, we receive #DIV/0! as a result.
To ignore this error, we can type the following formula into cell C2:
=IFERROR(A2/B2, "")
We can then copy and paste this formula down to every remaining cell in column C:
Now for each cell in column C where we attempt to divide by zero, we simply receive a blank value as a result.
Note that we could also use the following formula to return a zero as a result instead:
=IFERROR(A2/B2, 0)
The following screenshot shows how to use this formula in practice:
Now for each cell in column C where we attempt to divide by zero, we simply receive a zero as a result.
Note: Feel free to replace zero with whatever numeric or text value you’d like to display instead.
Additional Resources
The following tutorials explain how to perform other common tasks in Google Sheets:
Google Sheets: How to Sort and Ignore Blanks
Google Sheets: How to Ignore Blank Cells with Formulas
Google Sheets: How to Ignore #N/A Values
