Difference between revisions of "Manuals/calci/ISARRAYORSUCH"

Latest revision as of 14:08, 4 March 2019

ISARRAYORSUCH (SelectedArrayObject)

where

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 $ISARRAYORSUCH(SelectedArrayObject)$ , $SelectedArrayObject$ 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.

@@ Line 1: / Line 1: @@
 <div style="font-size:30px">'''ISARRAYORSUCH (SelectedArrayObject)'''</div><br/>
+where
+*<math>SelectedArrayObject</math> is the set of values.
 ==Description==
@@ Line 13: / Line 15: @@
 # ISARRAYORSUCH(3,10,"4") = false
 # ISARRAYORSUCH("a","r",5) = true
+==Related Videos==
+{{#ev:youtube|C7bA1jdn_Fo|280|center|Arrays in Excel}}
 ==See Also==
 *[[Manuals/calci/INSET  | INSET ]]
 *[[Manuals/calci/SUBSET  | SUBSET  ]]
-*[[Manuals/calci/EVENSET  | EVENSET ]]
+*[[Manuals/calci/ISARRAYORSUCHNOTSTRING  | ISARRAYORSUCHNOTSTRING ]]
 ==References==