Checks whether a reference is to an empty cell and returns TRUE or FALSE.
Cú pháp
ISBLANK(value)Đối số
valuebắt buộc
The value or cell reference you want to test.
The ISBLANK function determines if a specific cell reference contains no data. It returns TRUE if the cell is completely empty, and FALSE if the cell contains a value, a formula, or even an empty string result from a formula.
=ISBLANK(A1)→TRUEReturns TRUE if cell A1 is empty.
=ISBLANK("")→FALSEReturns FALSE because an empty string is considered a value.
Select the target cell
Click on the cell where you want the result of the ISBLANK function to appear.
Enter the formula
Type =ISBLANK( followed by the cell reference you want to check, then close the parenthesis.
Press Enter
Press the Enter key to execute the formula and view the logical result.
No, a cell containing a space is not considered empty, so it returns FALSE.