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:
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:
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:
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.
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