Difference between revisions of "Manuals/calci/SUBSET"
Jump to navigation
Jump to search
(Created page with "<div style="font-size:30px">'''SUBSET(GivenSubsetArray,GivenSuperSetArray)'''</div><br/> ==Description== *ISSUBSET function can be used to check the given subset array is a ...") |
(No difference)
|
Revision as of 06:31, 29 March 2017
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 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
- =SUBSET([],[1,2,3,4]) = true
- =SUBSET([1,2],[1,2,3,4])
- =SUBSET(["a"],["a",1,2,3,4])= true
- =SUBSET(["a"],["a","1","b"]) = true
- =SUBSET([a],[a]) = Sorry! a is not defined