ISBLANK

ISBLANK(value)

Returns the boolean 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 ISERROR function to return the boolean True or False depending if the value is an error.
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.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.

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