Difference between revisions of "Manuals/calci/ISARRAYORSUCHNOTSTRING"
Jump to navigation
Jump to search
(Created page with "<div style="font-size:30px">'''ISARRAYORSUCHNOTSTRING (SelectedArrayObject)'''</div><br/> *<math>SelectedArrayObject</math> is the set of values. ==Description== *This functi...") |
|||
| (2 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
<div style="font-size:30px">'''ISARRAYORSUCHNOTSTRING (SelectedArrayObject)'''</div><br/> | <div style="font-size:30px">'''ISARRAYORSUCHNOTSTRING (SelectedArrayObject)'''</div><br/> | ||
| + | where | ||
*<math>SelectedArrayObject</math> is the set of values. | *<math>SelectedArrayObject</math> is the set of values. | ||
| Line 5: | Line 6: | ||
*This function is one of the group in ISFUNCTIONS. | *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. | *The IS FUNCTION is also known as data information functions, data inspection functions or data-testing functions. | ||
| − | + | ISARRAYORSUCHNOTSTRING (SelectedArrayObject) | |
| + | *<math>SelectedArrayObject</math> 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. | *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. | *And will return the result as FALSE when the selected array object contaning single value or no value. | ||
| Line 15: | 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