Skip to content

valueForAlphabetic

Implementations

Microsoft Excel: AIDCT.valueForAlphabetic(s, exclusion, tweak)

Google Sheets: Google Sheets: aidctValueForAlphabetic(s, exclusion, tweak)

Get the value for an alphabetic string.

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

Parameters

NameTypeDescription
s**StringString for which to determine the value.
exclusionNumberString values to exclude. The only valid value is 0 (no exclusions).
tweakNumberValue 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.