Difference between revisions of "Manuals/calci/SUBSET"
Jump to navigation
Jump to search
| (One intermediate revision by the same user not shown) | |||
| Line 12: | Line 12: | ||
==Examples== | ==Examples== | ||
#=SUBSET([],[1,2,3,4]) = true | #=SUBSET([],[1,2,3,4]) = true | ||
| − | #=SUBSET([1,2],[1,2,3,4]) | + | #=SUBSET([1,2],[1,2,3,4]) = true |
#=SUBSET(["a"],["a",1,2,3,4])= true | #=SUBSET(["a"],["a",1,2,3,4])= true | ||
#=SUBSET(["a"],["a","1","b"]) = true | #=SUBSET(["a"],["a","1","b"]) = true | ||
#=SUBSET([a],[a]) = Sorry! a is not defined | #=SUBSET([a],[a]) = Sorry! a is not defined | ||
| + | |||
| + | ==Related Videos== | ||
| + | |||
| + | {{#ev:youtube|v=1wsF9GpGd00|280|center|Subset}} | ||
==See Also== | ==See Also== | ||
Latest revision as of 14:40, 31 January 2019
SUBSET(GivenSubsetArray,GivenSuperSetArray)
- and are any set of values.
and 
are any set of values.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 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.
given array is a subset of given superset array otherwise the result is false..
Examples
- =SUBSET([],[1,2,3,4]) = true
- =SUBSET([1,2],[1,2,3,4]) = true
- =SUBSET(["a"],["a",1,2,3,4])= true
- =SUBSET(["a"],["a","1","b"]) = true
- =SUBSET([a],[a]) = Sorry! a is not defined
Related Videos
See Also
References