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
| Name | Type | Description |
|---|---|---|
| s** | String | String to validate. |
| exclusion | Number | String 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.