Generally, Excel IF function evaluates where a cell is Blank or Not Blank to return a specified value in TRUE or FALSE arguments. Moreover, IF function also tests blank or not blank cells to control unexpected results while making comparisons in **logical_test** argument or making calculations in TRUE/FALSE arguments because Excel interprets blank cell as zero, and not as an empty or blank cell.

Syntax of IF function is;

**IF(logical_test, value_if_true, value_if_false)**

In IF statement to evaluate whether the cell is Blank or Not Blank, you can use either of the following approaches;

- Logical expressions Equal to Blank
**(=””)**or Not Equal to Blank**(<>””)**

- ISBLANK function to check blank or null values. If cell is blank then it returns TRUE, else returns FALSE.

Following examples will explain the difference to evaluate Blank or Not Blank cells using IF statement.

**Blank Cells**

To evaluate the cells as **Blank** you need to use either logical expression Equal to Blank **(=””) **of

function in**ISBLANK **

argument of IF formula. In both methods ** logical_test***logical_test* argument returns TRUE if cell is Blank, otherwise it returns FALSE if cell is Not Blank

For example you need to evaluate that if a cell is

then return blank value, otherwise return a value **Blank****“Delivered”**. In both approaches, following would be the IF formula;

**=IF(C2="","","Delivered")**

**OR**

**=IF(ISBLANK(C2),"","Delivered")**

In both of the approaches,

argument returns TRUE if cell is Blank, and **logical_test**

argument returns blank value, otherwise **value_if_true**

argument returns value **value_if_false****“Delivered”.**

**Not Blank Cells**

To evaluate the cells as

you need to use either logical expression Not Equal to Blank **Not Blank****(<>””) **of

function in**ISBLANK **

argument of IF formula. In case of logical expression Not Equal to Blank ** logical_test****(<>””)** *logical_test* argument returns TRUE if cell is Not Blank, otherwise it returns FALSE. In case of

function **ISBLANK**

argument returns FALSE if cell is Not Bank, otherwise it returns TRUE if cell is blank.**logical_test**

For example you need to evaluate that if a cell is

then return a value **Not Blank****“ Delivered”**, otherwise return a blank value. In both approaches, following would be the IF formula;

**=IF(C2<>"","Delivered","")**

In this approach logical expression Not Equal to Blank ** (<>“”) **returns TRUE in

**logical_test**

argument if cells is Not Blank, and **value_if_true**

argument returns a value **“Delivered”**, otherwise

**value_if_false**

argument a blank value.**OR**

**=IF(ISBLANK(C2),"","Delivered")**

This approach is opposite to first one above. In IF formula, ISBLANK function returns FALSE in

argument if cell is Not Blank, so **logical_test**

argument returns blank value and **value_if_true**

argument returns a value **value_if_false****“Delivered”**.

## Leave a Comment