Skip to main content

ISIN

The ISIN function checks if a value exists within a specified list of values.

Syntax​

=ISIN(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​

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