Navigation:  Formula Reference > Spreadsheet Formula Functions >

PERMUT

Previous pageReturn to chapter overviewNext page

 

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:

Func-PERMUT

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

 

See Also

COMBIN