Spread 8.0 Documentation
PERMUT
Support Options
Formula Reference > Built-In Functions > PERMUT

Glossary Item Box

PERMUT


Name

Permutation

Description

Returns the number of possible permutations for a specified number of items.

Syntax

PERMUT(value1, value2)

Remarks

Specify the number of items using the value1 argument. Specify the number of items in each possible permutation using the value2 argument. Both arguments must be positive integers, and the value1 argument must be greater than 0.

A permutation is any set or subset of items where internal order is significant. Contrast with combinations (the COMBIN function).

The number of permutations is calculated as follows:

See also COMBIN.

Data Type

Accepts numeric data for both arguments. Returns numeric data. For more information, see Data Type for Each Cell Type.

Example

PERMUT(R1C2,2)
PERMUT(B3,5)
PERMUT(C4,B2)
PERMUT(8,2)=56
PERMUT(100,3)=970200

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.