ISBLANK Function - Excel
Overview
The ISBLANK function in Excel is a useful tool for checking whether a specified cell is empty or not. This function returns a TRUE value if the given cell contains no data and it returns FALSE value if there is any content in the cell.
Example:
=ISBLANK("Apple")
Syntax:
=ISBLANK(value)
value: This is the value to the cell you want to check for emptiness.
TRUE Example
In this example, the ISBLANK function gives us the TRUE value result because the C2 cell is blank.
FALSE Example
In this example, the ISBLANK function gives us the FALSE value result because the C2 cell contains the value “Apple” and therefore is not blank.
