Manuals/calci/SUPERSET

From ZCubes Wiki
Revision as of 13:48, 16 May 2017 by Devika (talk | contribs)
Jump to navigation Jump to search
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