In Excel, if you want to check a cell if the value in it is 0 (zero) and you want a formula to return 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.
More Formulas
- Check IF a Value Exists in a Range in Excel
- Combine IF and AND Functions in Excel
- Combine IF and OR Functions in Excel
- IF Cell is Blank (Empty) using IF
- IF Negative Then Zero (0) in Excel
- Check IF a Cell Contains a Partial Text
- Check IF a Cell Value is a Number
- If a Cell Value Starts with a Text or a Number
- Median with IF (Conditional Criteria)
And, if you want to Get Smarter than Your Colleagues check out these FREE COURSES to Learn Excel, Excel Skills, and Excel Tips and Tricks.