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.
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.
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).
Once we are done, you will be able to return blank cell instead of zero.