Manuals/calci/SUPERSET

Revision as of 05:29, 29 March 2017 by Jayaram (talk | contribs) (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...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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.


Examples

  1. =SUPERSET([1,2,3,4],[]) = true
  2. =SUPERSET([1,2,3,4],[1,2]) =true
  3. =SUPERSET(["a"],["a",1,2,3,4])= false
  4. =SUPERSET(["a","1","b"],["a"]) = true
  5. =SUPERSET([a],[a]) = Sorry! a is not defined