Difference between revisions of "Manuals/calci/ISARRAY"
Jump to navigation
Jump to search
(Created page with "<div style="font-size:30px">'''ISARRAY(Array)'''</div><br/> *<math>Array</math> is the value to test. ==Description== *This function checks whether the entered set of argume...") |
(No difference)
|
Latest revision as of 04:55, 30 May 2017
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
- ISARRAY([1,5,6,4,9]) = true
- ISARRAY(11,12,13) = false
- ISARRAY(["red", "blue", "green", "yellow", "pink"]) = true
- ISARRAY([true, false, 0.5, 6]) = true
- ISARRAY(1..9) = true
- ISARRAY([7,9,"NAME", 0]) = true
- ISARRAY(100) = false
Related Videos
See Also
References