Difference between revisions of "Manuals/calci/ISNUMBERSYMBOLS"

From ZCubes Wiki
Jump to navigation Jump to search
 
Line 18: Line 18:
 
#=ISNUMBERSYMBOLS("*") = TRUE
 
#=ISNUMBERSYMBOLS("*") = TRUE
 
#=ISNUMBERSYMBOLS(-100) = TRUE
 
#=ISNUMBERSYMBOLS(-100) = TRUE
−
#=ISNUMBERSYMBOLS(")") = TRUE
+
#=ISNUMBERSYMBOLS(")") = false
−
#=ISNUMBERSYMBOLS(["*","&","$"]) = TRUE
+
#=ISNUMBERSYMBOLS(["*","&","$"]) = false
  
 
==Related Videos==
 
==Related Videos==

Latest revision as of 13:10, 24 May 2018

ISNUMBERSYMBOLS(Array)


  • is array of numbers or symbols.

Description

  • function checks whether the given value is a number or any symbol.
  • This function is one of the group in .
  • The is also known as data information functions, data inspection functions or data-testing functions.
  • Result is 'TRUE' when the given value is a number or a symbol. Else the result is 'FALSE'.


ZOS

  • The syntax is to find whether the given data is a number or a symbol in ZOS is .
    • is any number or symbol.
  • For e.g.,ISNUMBERSYMBOLS(7,"&"),ISNUMBERSYMBOLS(sum(10,20,30,40,50))

Examples

  1. =ISNUMBERSYMBOLS(2) = TRUE
  2. =ISNUMBERSYMBOLS("*") = TRUE
  3. =ISNUMBERSYMBOLS(-100) = TRUE
  4. =ISNUMBERSYMBOLS(")") = false
  5. =ISNUMBERSYMBOLS(["*","&","$"]) = false

Related Videos

ISNUMBER

See Also

References

Is functions


Retrieved from "http://wiki.zcubes.com/index.php?title=Manuals/calci/ISNUMBERSYMBOLS&oldid=210054"