You can use the following basic syntax to return a blank instead of a zero when using formulas in Google Sheets:

=IF(B2/C2=0, "", B2/C2)

This particular formula attempts to divide the value in cell **B2** by the value in cell **C2**.

If the result is zero, then Google Sheets returns a blank.

Otherwise, it returns the result of **B2** divided by **C2**.

The following example shows how to use this formula in practice.

**Example: Return Blank Instead of Zero in Google Sheets Formula**

Suppose we have the following dataset that shows the total sales and returns for various products:

Suppose we type the following formula into cell **D2** to calculate the return rate for product A:

=B2/C2

If we click and drag this formula down to every cell in column D, we’ll see that some of the results are equal to zero:

To return a blank value instead of a zero, we can type the following formula into cell **D2**:

=IF(B2/C2=0, "", B2/C2)

We can then click and drag this formula down to every remaining cell in column D:

Notice that every cell where the formula would return a zero now returns a blank value instead.

**Additional Resources**

The following tutorials explain how to perform other common tasks in Google Sheets:

How to Replace #N/A Values in Google Sheets

How to Replace Text in Google Sheets

How to Replace Space with Dash in Google Sheets