In this tutorial, you will learn how to return blank cell instead of zero in Excel.

By default, when an Excel formula’s return cell is empty, Excel returns 0 instead. For example, cell A1 is blank and linked to another cell. But what if you want to see the exact return value for both empty cells and 0 as the return value?

Once you are ready, we can start by using real-life scenarios to help you understand how to return blank cell instead of zero in Excel.

Table of Contents

## Return Blank Cell Instead of Zero

Before we begin we will need a group of data to be used to return blank cell instead of zero in Excel.

### Step 1

First, you need to have a clean and tidy group of data to work with. As you can see, for subtraction that equals to zero, Excel will return “0” instead of blank.

### Step 2

In order to return a blank cell instead of “0”, we can use the IF function. We can insert the following formula =IF(A2-B2=0,””,A2-B2).

### Step 3

Once we are done, you will be able to return blank cell instead of zero.