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.
* 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 


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