Manuals/calci/ISARRAYORSUCHNOTSTRING

ISARRAYORSUCHNOTSTRING (SelectedArrayObject)


where

  • is the set of values.

Description

  • This function is one of the group in ISFUNCTIONS.
  • The IS FUNCTION is also known as data information functions, data inspection functions or data-testing functions.

ISARRAYORSUCHNOTSTRING (SelectedArrayObject)

  •   is the set of values not including string values.
  • This function is giving the result as TRUE when the selected Array Object is containing set of values but not including string values.
  • And will return the result as FALSE when the selected array object contaning single value or no value.
  • For the ISFUNCTION the argument can be blank, or it can contain data such as text, numbers, error values, or logical values.

Examples

  1. ISARRAYORSUCHNOTSTRING(2,3,4,7,90) = false
  2. ISARRAYORSUCHNOTSTRING(10,"y") = false
  3. ISARRAYORSUCHNOTSTRING([10,11,78]) = true
  4. ISARRAYORSUCHNOTSTRING(["r","g","e"]) = true

Related Videos

Arrays in Excel

See Also

References