Manuals/calci/SUBSET

SUBSET(GivenSubsetArray,GivenSuperSetArray)

Description

• ISSUBSET function can be used to check the given subset array is a subset of given superset array or not.
• This function gives the result as TRUE or FALSE.
• The result is TRUE when the $n$ given array is a subset of given superset 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. =SUBSET([],[1,2,3,4]) = true
2. =SUBSET([1,2],[1,2,3,4])
3. =SUBSET(["a"],["a",1,2,3,4])= true
4. =SUBSET(["a"],["a","1","b"]) = true
5. =SUBSET([a],[a]) = Sorry! a is not defined