Manuals/calci/ISARRAY

ISARRAY(Array)

• $Array$ is the value to test.

Description

• This function checks whether the entered set of arguments is an array or not.
• Array is a data structure consisting of a collection of elements (values or variables), each identified by at least one array index or key.
• This function will return the result as TRUE when given value or referred cell is an array, otherwise the result is FALSE.
• The argument can be blank, or it can contain data such as text, numbers, logical values etc.

Examples

1. ISARRAY([1,5,6,4,9]) = true
2. ISARRAY(11,12,13) = false
3. ISARRAY(["red", "blue", "green", "yellow", "pink"]) = true
4. ISARRAY([true, false, 0.5, 6]) = true
5. ISARRAY(1..9) = true
6. ISARRAY([7,9,"NAME", 0]) = true
7. ISARRAY(100) = false

Related Videos

Arrays in Excel

See Also

• ISLOGICAL
• ISTEXT

References

Is Function Array

• List of Main Z Functions

• Z3 home