Skip to content

isValidNumeric

Implementations

Microsoft Excel: AIDCT.isValidNumeric(s, exclusion)

Google Sheets: Google Sheets: aidctIsValidNumeric(s, exclusion)

Determine if a string is numeric.

This function returns a matrix of values of the same shape and size as the s parameter.

Parameters

NameTypeDescription
s**StringString to validate.
exclusionNumberString values to exclude. Valid values are 0 (no exclusions) and 1 (strings starting with 0 excluded).

Parameters in italics are optional.

** This parameter accepts a single value, an array of values, or a matrix of values.