Difference between revisions of "Manuals/calci/SUPERSET"
Jump to navigation
Jump to search
(Created page with "<div style="font-size:30px">'''ISSUPERSET(SubsetArray,SuperSetArray)'''</div><br/> ==Description== *SUPERSET function can be used to check the given array is a superset of giv...") |
|||
| Line 1: | Line 1: | ||
<div style="font-size:30px">'''ISSUPERSET(SubsetArray,SuperSetArray)'''</div><br/> | <div style="font-size:30px">'''ISSUPERSET(SubsetArray,SuperSetArray)'''</div><br/> | ||
| + | |||
==Description== | ==Description== | ||
*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. | ||
Revision as of 14:48, 16 May 2017
ISSUPERSET(SubsetArray,SuperSetArray)
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 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.
given array is a superset of given subset array otherwise the result is false..
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