Difference between revisions of "Manuals/calci/ISSUBSET"
Jump to navigation
Jump to search
(Created page with "<div style="font-size:30px">'''ISSUBSET(GivenSubsetArray,GivenSuperSetArray)'''</div><br/> ==Description== *This function is one of the group in ISFUNCTIONS. *The IS FUNCTION...") |
|||
| (One intermediate revision by the same user not shown) | |||
| Line 12: | Line 12: | ||
==Examples== | ==Examples== | ||
#=ISSUBSET([],[1,2,3,4]) = true | #=ISSUBSET([],[1,2,3,4]) = true | ||
| − | #=ISSUBSET([1,2],[1,2,3,4]) | + | #=ISSUBSET([1,2],[1,2,3,4]) = true |
#=ISSUBSET(["a"],["a",1,2,3,4])= true | #=ISSUBSET(["a"],["a",1,2,3,4])= true | ||
#=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 20: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.
given array is a subset of given superset array otherwise the result is false..
Examples
- =ISSUBSET([],[1,2,3,4]) = true
- =ISSUBSET([1,2],[1,2,3,4]) = true
- =ISSUBSET(["a"],["a",1,2,3,4])= true
- =ISSUBSET(["a"],["a","1","b"]) = true
- =ISSUBSET([a],[a]) = Sorry! a is not defined
Related Videos
See Also
References