Manuals/calci/ISARRAYORSUCH

ISARRAYORSUCH (SelectedArrayObject)

where

• $SelectedArrayObject$ is the set of values.

Description

• This function is one of the group in ISFUNCTIONS.
• The ISFUNCTION is also known as data information functions, data inspection functions or data-testing functions.
• In $ISARRAYORSUCH(SelectedArrayObject)$,$SelectedArrayObject$ is the set of values.
• This function is giving the result as TRUE when the selected Array Object is containing set of values including string values.
• And will return the result as FALSE when the selected array object containing single value or no value.
• For the ISFUNCTION the argument can be blank, or it can contain data such as text, numbers, error values, or logical values.

Examples

1. ISARRAYORSUCH(2,[2,3,4]) = false
2. ISARRAYORSUCH(3,10,"4") = false
3. ISARRAYORSUCH("a","r",5) = true

Related Videos

Arrays in Excel

See Also

• INSET
• SUBSET
• ISARRAYORSUCHNOTSTRING

References

• Set

• List of Main Z Functions
• Z3 home