Skip to main content

This version of the product is no longer supported, and this documentation is no longer updated regularly. See the latest version of this content.Opens in a new tab

NUM

Returns whether a value is numeric.

Synopsis

NUM(string)

Arguments

string An expression that resolves to a string or numeric.

Description

The NUM function determines whether a value is numeric or non-numeric. If string is a non-numeric value, NUM returns 0. If string is a numeric value, NUM returns 1. A numeric value can contain the numerals 0 through 9, plus and minus signs, and the decimal point. NUM also returns 1 for the null string.

You can use the NUMS function to make the same determination of each element of a dynamic array.

See Also

FeedbackOpens in a new tab