From ZCubes Wiki
Jump to navigation Jump to search

  • is the value to test.


  • 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.


  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


Is Function Array