Manuals/calci/ISARRAY

ISARRAY(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


References

Is Function Array