Checks whether a reference is to an empty cell and returns TRUE or FALSE.
ไวยากรณ์
ISBLANK(value)อาร์กิวเมนต์
valueจำเป็น
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.