Skip to content

valueForHexadecimal

Implementations

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

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

Get the value for a hexadecimal 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. Valid values are 0 (no exclusions), 1 (strings starting with 0 excluded), and 2 (strings that are all numeric excluded).
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.