ISBLANK

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:

ISBLANK function. Example of use

Category
Information
Submitted by admin on Tue, 12/04/2018 - 12:06