To work with the tool in Foresight Analytics Platform 10, use the new interface.
The function wizard for the RndPermutation function looks as follows:
RndPermutation(Value)
Value. Dimension of the required array, the greatest value in it. Parameter value cannot be less than one.
NOTE. To determine the parameter, specify either the number or the address of the cell where it is located.
It returns an array that is an arbitrary permutation of another array, which elements are integers ranging from 1 to the value of the passed parameter.
Formula | Result | Description |
= RndPermutation(A1) | Changes. | A random number between one and the value stored in the A1 cell. |
= RndPermutation(5) | Changes. | A random value between 1 and 5. |
See also:
Function Wizard │ Mathematical Functions │ IMath.RndPermutation