Manuals/calci/SUPERSET

From ZCubes Wiki
Revision as of 13:40, 4 February 2019 by Devika (talk | contribs) (→‎Examples)
Jump to navigation Jump to search
SUPERSET (GivenSubsetArray,GivenSuperSetArray)


  • 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

  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


Related Videos

SUMIF

See Also

References