Manuals/calci/ISSUPERSET

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 $n$ 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

1. =ISSUPERSET([1,2,3,4],[]) = true
2. =ISSUPERSET([1,2,3,4],[1,2]) =true
3. =ISSUPERSET(["a"],["a",1,2,3,4])= false
4. =ISSUPERSET(["a","1","b"],["a"]) = true
5. =ISSUPERSET([a],[a]) = Sorry! a is not defined