Difference between revisions of "Manuals/calci/ISSAME"

From ZCubes Wiki
Jump to navigation Jump to search
(Created page with "<div style="font-size:30px">'''ISSAME(GivenSetOneArray,GivenSetTwoArray)'''</div><br/> *where <math>GivenSetOneArray<\math> and <math>GivenSetTwoArray<\math> are two arrays t...")
 
Line 1: Line 1:
 
<div style="font-size:30px">'''ISSAME(GivenSetOneArray,GivenSetTwoArray)'''</div><br/>
 
<div style="font-size:30px">'''ISSAME(GivenSetOneArray,GivenSetTwoArray)'''</div><br/>
  
*where <math>GivenSetOneArray<\math> and <math>GivenSetTwoArray<\math> are two arrays to be compared.
+
*where <math>GivenSetOneArray</math> and <math>GivenSetTwoArray</math> are two arrays to be compared.
  
 
==Description==
 
==Description==
Line 15: Line 15:
  
 
==Examples==
 
==Examples==
#=ISSUBSET([],[1,2,3,4]) = true
+
#=ISSAME([1,2,3,4],[1,2,3,4]) = true
#=ISSUBSET([1,2],[1,2,3,4])
+
#=ISSAME([1,2],[1,2,3,4]) = false
#=ISSUBSET(["a"],["a",1,2,3,4])= true
+
#=ISSAME(["a"],["a"])= true
#=ISSUBSET(["a"],["a","1","b"]) = true
+
#=ISSAME(["a"],["a","1","b"]) = false
#=ISSUBSET([a],[a]) = Sorry! a is not defined
 

Revision as of 20:49, 15 May 2017

ISSAME(GivenSetOneArray,GivenSetTwoArray)


  • where and are two arrays to be compared.

Description

  • ISSAME function can be used to check the given two arrays are same or not.
  • This function is one of the function in ISFUNCTIONS group.
  • The IS FUNCTION is also known as Data Information Functions, Data Inspection Functions or Data-testing Functions.
  • This function gives the result as TRUE or FALSE.
  • The result is TRUE when the two arrays are same. Else 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. =ISSAME([1,2,3,4],[1,2,3,4]) = true
  2. =ISSAME([1,2],[1,2,3,4]) = false
  3. =ISSAME(["a"],["a"])= true
  4. =ISSAME(["a"],["a","1","b"]) = false