Check IF 0 (Zero) Then Blank (Formula in Excel)

puneet-gogia-excel-champs

- Written by Puneet

In Excel, if you want to check a cell if its value is 0 (zero) and you want a formula to return a blank in the result, you can use the IF function. In IF, you need to specify the cell from which you want to check the 0 and then specify the blank values 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 you must write a condition.

numbers-list

Formula to Check IF 0 (Zero) Then Blank

  1. First, edit cell B2, enter the (=), and then enter the IF function to start the formula.
  2. After that, in the first argument, specify the condition to check values from cell A2 (A2=0).
  3. Now, in the second argument, specify a zero.
  4. And in the third argument, refer to cell A2 back.
  5. In the end, enter the closing parentheses.
if-formula-to-find-zero

Here’s the formula to check if a cell has a zero value and change it to a zero.

=IF(A2=0,"",A2)

How this Formula Works

Now, let’s try to understand how this formula works.

optional-parts-of-if-formula

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.

IF – We have used the IF function to write a conditional formula.

A2=0 This is the condition where we compare the value in cell A2 with 0. This is the part where we will get the condition’s result as TRUE or FALSE. If the condition is TRUE (that means the value in the cell is 0), and if the condition is FALSE (that means the value in the cell is not zero).

if-formula-with-false

“”,A2 – These are the two returning values which the formula returns, when conditions is met or doesn’t met.

Last Updated: March 24, 2024