Skip to content

reverseTransform

Implementations

Microsoft Excel: AIDCT.reverseTransform(domain, transformedValue, tweak)

Google Sheets: Google Sheets: aidctReverseTransform(domain, transformedValue, tweak)

Transform a value in reverse.

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

Parameters

NameTypeDescription
domainNumberTransformation domain. Valid input values are from 0 to domain-1.
transformedValue**NumberPrevious output value of a transformation.
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.