Returns the boolean value true if the value passed to the function is blank else returns false.
= ISBLANK(value)
Value |
A value which has to be checked. The value can be specified as a decimal value (e.g., 37.48), as a string (“ “), as an expression (e.g., 1+1=2), or as the value of a variable (e.g, ShippedDate). |
Boolean
Example |
Returns |
= ISBLANK(30) |
False |
= ISBLANK(“ “) |
True |
= ISBLANK(1+1=2) |
False |
= ISBLANK(ShippedDate) |
True if the value of ShippedDate is blank or null else returns false |