Manuals/calci/ISSAME

Revision as of 20:49, 15 May 2017 by Swapna (talk | contribs)
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