Spread Formula Reference
PERMUT
Formula Functions > Functions M to Q > PERMUT

This function returns the number of possible permutations for a specified number of items.

Syntax

PERMUT(k,n)

Arguments

This function has these arguments:

Argument Description
k Number of items; must be greater than 0; if not an integer, the number is truncated
n Number of items in each possible permutation; must be positive or 0; if not an integer, the number is truncated

Remarks

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

The equation for this function is:

PERMUT Equation

where k and n are defined in the arguments.

Data Types

Accepts numeric data for both arguments. Returns numeric data.

Examples

PERMUT(B3,5)

PERMUT(C4,B2)

PERMUT(R1C2,2)

PERMUT(8,2) gives the result 56

PERMUT(100,3) gives the result 970200

Version Available

This function is available in product version 1.0 or later.

See Also

COMBIN | Math and Trigonometry Functions