Skip to content
Adaptam Docs

IS_NOT_BLANK

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

Examples

  • IS_NOT_BLANK(A1) - Returns TRUE if A1 has a formula (not an empty cell) and its value is not blank (null).
  • IS_NOT_BLANK(0) - Returns TRUE. Zero is a value, not blank.