To work with the tool in Foresight Analytics Platform 10, use the new interface.

RndPermutation

The function wizard for the RndPermutation function looks as follows:

Syntax

RndPermutation(Value)

Parameters

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.

Description

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.

Example

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 FunctionsIMath.RndPermutation