The ISBLANK function evaluates whether or not a value takes the value Blank and returns True if it is positive or False if it is negative.
Syntax
ISBLANK(
value
)
Parameters
- value: Value or expression to evaluate.
Returned value
The ISBLANK function returns a Boolean.
Examples
The following example calculates the sales increase between 2015 and 2016 and, in the last column, the text "Conocido" ("Known") or "Desconocido" ("Unknown") is returned depending on whether the value in the "Incremento" ("Increase") column is a Blank or not:
Scenarios
Category
Information