Skip to main content

NOTIN

The NOTIN function checks if a value does not exist within a specified list of values.

Syntax​

=NOTIN(value, value1, [value2], ...)

Parameters​

  • value: The value to search for
  • value1: The first value to compare against
  • value2, ...: Optional. Additional values to compare against

Examples​

=NOTIN(5, 1, 3, 7) // Returns TRUE
=NOTIN("apple", "banana", "orange") // Returns TRUE
=NOTIN(3, 1, 2, 3) // Returns FALSE