ISBLANK

ISBLANK(value)

Returns the boolean True or False depending if the value is blank.

value

The value you want to test.

REMARKS

* The "value" can refer to a value, cell reference, formula or named range.
* You can use the ISERROR function to return the boolean True or False depending if the value is an error.
* This function has been available since Excel 1997.
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com

	A	B
1	=ISBLANK(B1) = False	False
2	=ISBLANK(B2) = True
3	=ISBLANK("") = False
4	=ISBLANK(12) = False
5	=ISBLANK("some text") = False
6	=ISBLANK(named_range) = True

1 - Is cell "B1" blank.
2 - Is cell "B2" blank.
3 - Is an empty string considered blank.
4 - Is a numerical value considered blank.
5 - Is a text string considered blank.
6 - Is a named range (of a blank cell) considered blank.