In Excel, if you want to check a cell if the value in it is 0 (zero) and you want a formula to return a blank in the result, you can use the IF function for this. In IF, you need to specify the cell from which you want to check the 0 and then specify the blank values that you want to get in the result once the condition is TRUE.
In the following example, we have a list of numbers in column A and now you need to write a condition.
Formula to Check IF 0 (Zero) Then Blank
- First, in cell B2, enter the IF function.
- After that, in the first argument, specify the condition to check values from cell A2 (A2=0).
- Now, in the second argument, specify a zero.
- And in the third argument, refer to cell A2 back.
- In the end, enter the closing parentheses.
Here’s the formula that you need to use to check if a cell has a zero value and changes it to a zero.
=IF(A2=0,"",A2)
Now let’s try to understand how this formula works. This formula works in three parts, in the first part where we have a condition that checks if the cell has a value) or not.
Now next two-part as optional and work according to the result from the condition.
If the condition is TRUE (that means the value in the cell is 0), you’ll get the blank value, and if the condition is FALSE, you will have the value from the original cell.