Manuals/calci/ISSUPERSET
Jump to navigation
Jump to search
ISSUPERSET(SubsetArray,SuperSetArray)
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.
- ISSUPERSET function can be used to check the given array is a superset of given subset array or not.
- This function gives the result as TRUE or FALSE.
- The result is TRUE when the given array is a superset of given subset array otherwise the result is false..
- The argument can be blank, or it can contain data such as text,numbers,error values,logical values or any equations.
- Text input should be give in quotes.
Examples
- =ISSUPERSET([1,2,3,4],[]) = true
- =ISSUPERSET([1,2,3,4],[1,2]) =true
- =ISSUPERSET(["a"],["a",1,2,3,4])= false
- =ISSUPERSET(["a","1","b"],["a"]) = true
- =ISSUPERSET([a],[a]) = Sorry! a is not defined
Related Videos
See Also
References