valueForNumeric
Implementations
Microsoft Excel: AIDCT.valueForNumeric(s, exclusion, tweak)
Google Sheets: Google Sheets: aidctValueForNumeric(s, exclusion, tweak)
Get the value for a numeric string.
This function returns a matrix of values of the same shape and size as the s parameter.
Parameters
| Name | Type | Description |
|---|---|---|
| s** | String | String for which to determine the value. |
| exclusion | Number | String values to exclude. Valid values are 0 (no exclusions) and 1 (strings starting with 0 excluded). |
| tweak | Number | Value by which to tweak the transformation. If not provided or zero, the output is sequential. Otherwise, the output is encrypted in such a way as to appear random, masking the values used as inputs to the sequence. |
Parameters in italics are optional.
** This parameter accepts a single value, an array of values, or a matrix of values.