Manuals/calci/SUBSET

Revision as of 14:40, 31 January 2019 by Devika (talk | contribs) (→‎Examples)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
SUBSET(GivenSubsetArray,GivenSuperSetArray)


  • and are any set of values.

Description

  • ISSUBSET function can be used to check the given subset array is a subset of given superset array or not.
  • This function gives the result as TRUE or FALSE.
  • The result is TRUE when the   given array is a subset of given superset 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. =SUBSET([],[1,2,3,4]) = true
  2. =SUBSET([1,2],[1,2,3,4]) = true
  3. =SUBSET(["a"],["a",1,2,3,4])= true
  4. =SUBSET(["a"],["a","1","b"]) = true
  5. =SUBSET([a],[a]) = Sorry! a is not defined

Related Videos

Subset

See Also

References