Difference between revisions of "Manuals/calci/ISSUBSET"

From ZCubes Wiki
Jump to navigation Jump to search
 
Line 16: Line 16:
 
#=ISSUBSET(["a"],["a","1","b"]) = true
 
#=ISSUBSET(["a"],["a","1","b"]) = true
 
#=ISSUBSET([a],[a]) = Sorry! a is not defined
 
#=ISSUBSET([a],[a]) = Sorry! a is not defined
 +
 +
==Related Videos==
 +
 +
{{#ev:youtube|HMmKFvvteyU|280|center|Analyzing Subsets and Groups}}
 +
 +
==See Also==
 +
*[[Manuals/calci/ISSUPERSET  | ISSUPERSET ]]
 +
*[[Manuals/calci/ISEVEN  | ISEVEN ]]
 +
*[[Manuals/calci/ISODD  | ISODD ]]
 +
*[[Manuals/calci/ISNUMBER  | ISNUMBER ]]
 +
*[[Manuals/calci/ISNONTEXT  |ISNONTEXT ]]
 +
 +
==References==
 +
*[http://en.wikipedia.org/wiki/Is_functions  Is Function]
 +
 +
 +
 +
*[[Z_API_Functions | List of Main Z Functions]]
 +
 +
*[[ Z3 |  Z3 home ]]

Latest revision as of 21:10, 7 March 2018

ISSUBSET(GivenSubsetArray,GivenSuperSetArray)


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.
  • 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. =ISSUBSET([],[1,2,3,4]) = true
  2. =ISSUBSET([1,2],[1,2,3,4]) = true
  3. =ISSUBSET(["a"],["a",1,2,3,4])= true
  4. =ISSUBSET(["a"],["a","1","b"]) = true
  5. =ISSUBSET([a],[a]) = Sorry! a is not defined

Related Videos

Analyzing Subsets and Groups

See Also

References