Building Report for Printing > Building Report > Using Table Sheet > Adding a New Sheet and Working with It > Working with Table Sheet Data > Using Formulas > Function Wizard > Mathematical Functions > RndPermutation
The function wizard for the RndPermutation function looks as follows:
RndPermutation(Value)
Value. Dimension of the required array, 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 │ IMath.RndPermutation
