Manuals/calci/ISNUMBERSYMBOLS

Revision as of 13:10, 24 May 2018 by Devika (talk | contribs) (→‎Examples)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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