Manuals/calci/ISARRAYORSUCHNOTSTRING

ISARRAYORSUCHNOTSTRING (SelectedArrayObject)

where

• $SelectedArrayObject$ 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)

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

• INSET
• SUBSET
• ISARRAYORSUCH

References

• Set

• List of Main Z Functions
• Z3 home