VALUE_IN

Description

Returns TRUE if the provided value matches any of the specified compare values; otherwise, returns FALSE.

Syntax

VALUE_IN(value, ...compare_values) -> Boolean

Parameters

ParameterData TypeRequiredDescription
valueObjectYesThe value to evaluate.
...compare_valuesObjectYesOne or more values to compare against.

Examples

VALUE_IN(3, 1, 2, 3)
-- Returns TRUE because 3 is one of the provided compare values.
VALUE_IN(SUBSTRING_AFTER(Email, "@"), "nvidia.com", "amd.com", "tesla.com")
-- Returns TRUE if the email domain matches any specified domain ("nvidia.com", "amd.com", or "tesla.com").

Related Formula