ISBLANK(value)

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

valueThe value you want to test.

Remarks

* The "value" can refer to a value, cell reference, formula or named range.
* You can use the ISERR function to indicate if the value is an error (excluding #N/A).
* You can use the ISERROR function to return the value True or False depending if the value is an error.
* For the Microsoft documentation refer to support.office.com

 AB
1=ISBLANK(B1) = FalseFalse
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.

© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited Top