Difference between revisions of "Manuals/calci/ISARRAYORSUCHNOTSTRING"
Jump to navigation
Jump to search
| (One intermediate revision by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | =ISARRAYORSUCHNOTSTRING (SelectedArrayObject) | + | <div style="font-size:30px">'''ISARRAYORSUCHNOTSTRING (SelectedArrayObject)'''</div><br/> |
| − | |||
where | where | ||
*<math>SelectedArrayObject</math> is the set of values. | *<math>SelectedArrayObject</math> is the set of values. | ||
| Line 18: | Line 17: | ||
# ISARRAYORSUCHNOTSTRING([10,11,78]) = true | # ISARRAYORSUCHNOTSTRING([10,11,78]) = true | ||
# ISARRAYORSUCHNOTSTRING(["r","g","e"]) = true | # ISARRAYORSUCHNOTSTRING(["r","g","e"]) = true | ||
| + | |||
| + | ==Related Videos== | ||
| + | |||
| + | {{#ev:youtube|C7bA1jdn_Fo|280|center|Arrays in Excel}} | ||
==See Also== | ==See Also== | ||
Latest revision as of 14:07, 4 March 2019
ISARRAYORSUCHNOTSTRING (SelectedArrayObject)
where
- is the set of values.
is the set of values.Description
- This function is one of the group in ISFUNCTIONS.
- The IS FUNCTION is also known as data information functions, data inspection functions or data-testing functions.
ISARRAYORSUCHNOTSTRING (SelectedArrayObject)
- is the set of values not including string values.
- This function is giving the result as TRUE when the selected Array Object is containing set of values but not including string values.
- And will return the result as FALSE when the selected array object contaning 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
- ISARRAYORSUCHNOTSTRING(2,3,4,7,90) = false
- ISARRAYORSUCHNOTSTRING(10,"y") = false
- ISARRAYORSUCHNOTSTRING([10,11,78]) = true
- ISARRAYORSUCHNOTSTRING(["r","g","e"]) = true
Related Videos
See Also
References