Difference between revisions of "Manuals/calci/SUPERSET"
Jump to navigation
Jump to search
| (2 intermediate revisions by the same user not shown) | |||
| Line 5: | Line 5: | ||
*SUPERSET function can be used to check the given array is a superset of given subset array or not. | *SUPERSET 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. | *This function gives the result as TRUE or FALSE. | ||
| − | *The result is TRUE when the | + | *The result is TRUE when the given array of value 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. | *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. | *Text input should be give in quotes. | ||
| − | |||
==Examples== | ==Examples== | ||
| Line 16: | Line 15: | ||
#=SUPERSET(["a","1","b"],["a"]) = true | #=SUPERSET(["a","1","b"],["a"]) = true | ||
#=SUPERSET([a],[a]) = Sorry! a is not defined | #=SUPERSET([a],[a]) = Sorry! a is not defined | ||
| + | |||
| + | |||
| + | ==Related Videos== | ||
| + | |||
| + | {{#ev:youtube|v=1wsF9GpGd00&t=1s|280|center|SuperSet}} | ||
==See Also== | ==See Also== | ||
Latest revision as of 13:41, 4 February 2019
SUPERSET (GivenSubsetArray,GivenSuperSetArray)
- and are set of array values.
and 
are set of array values.Description
- SUPERSET 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 of value 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
- =SUPERSET([1,2,3,4],[]) = true
- =SUPERSET([1,2,3,4],[1,2]) =true
- =SUPERSET(["a"],["a",1,2,3,4])= false
- =SUPERSET(["a","1","b"],["a"]) = true
- =SUPERSET([a],[a]) = Sorry! a is not defined