Skip to content
Adaptam Docs

IS_BLANK

Returns TRUE if the specified value or cell is empty, otherwise FALSE. A cell is blank when it has no formula, or when its formula produces a blank (null) value. Zero is a value, not blank — IS_BLANK(0) returns FALSE.

Examples

  • IS_BLANK(A1) - Returns TRUE if A1 is an empty cell (no formula) or a cell with a blank (null) value.
  • IS_BLANK(0) - Returns FALSE. Zero is a value, not blank.