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