ISBLANK Formula In Excel

Let’s see how to check blank cell in excel.

ISBLANK () formula in excel is used to check blank cell in excel and return true or false depending whether the cell is blank or not respectively.

ISBLANK (value) takes reference to a cell and returns true/false.

We are interested to check what are the blanks cell in the below given column.

Capture

Enter the ISBLANK(reference) formula as shown below.

Capture




As shown below, the TRUE value indicates the blank cells.

Capture

Hope this helped.

Share The Knowledge

Random Posts

Leave a Reply