Manuals/calci/ISSUPERSET

Revision as of 20:12, 7 March 2018 by Swapna (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
ISSUPERSET(SubsetArray,SuperSetArray)


Description

  • This function is one of the group in ISFUNCTIONS.
  • The IS FUNCTION is also known as Data Information Functions, Data Inspection Functions or Data-testing Functions.
  • ISSUPERSET 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. =ISSUPERSET([1,2,3,4],[]) = true
  2. =ISSUPERSET([1,2,3,4],[1,2]) =true
  3. =ISSUPERSET(["a"],["a",1,2,3,4])= false
  4. =ISSUPERSET(["a","1","b"],["a"]) = true
  5. =ISSUPERSET([a],[a]) = Sorry! a is not defined

Related Videos

Analyzing Subsets and Groups

See Also

References