From ZCubes Wiki
Jump to navigation Jump to search

  • where and are two arrays to be compared.


  • 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.


  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

Related Videos

Is Error

See Also