Checks whether the specified reference identifies an empty cell.
Syntax
 Copy Code
|
|---|
ISBLANK( Any x ) → Logical |
Parameters
- x
- Required. The value to check.
Remarks
If x is a reference to an empty cell, that is, a cell with no data, the function returns TRUE. If x is a number, logical value or text, or a reference to a cell that is not empty, the function returns FALSE. If the cell contains an empty string, it is not considered blank.
Example
| Formula
Copy Code
|
|---|
=ISBLANK(A1) |
See Also
Function Reference
ERROR.TYPE Function
ISERR Function
ISERROR Function
ISNA Function
ISREF Function
ISTEXT Function
TYPE Function