ID EN
#Statistical

PERMUT

Excel Functions

Get number of permutations without repetitions

Syntax

EXCEL
=PERMUT(number, number_chosen)

Arguments

Parameter Description
number The total number of items.
number_chosen The number of items in each combination.

Return Value

Number of permutations as an integer

Details

The PERMUT function returns the number of permutations for a given number of items. A permutation is a combination where order matters. In other words, a permutation is an ordered combination. There are two types of permutations: The PERMUT function calculates permutations where repetitions are not allowed. To calculate permutations where repetitions are allowed, use the PERMUTATIONA function. A good real-world example is a race: if 10 runners compete, how many ways can 1st, 2nd, and 3rd place be awarded? Order matters and no runner can finish in two positions, so this is a permutation without repetition. For a full explanation, see Combinations and permutations in Excel. To use PERMUT, specify the total number of items and "number_chosen", which represents the number of items in each comb

Examples

Example

To use PERMUT, specify the total number of items and "number_chosen", which represents the number of items in each combination. For example, to calcul

EXCEL
=PERMUT(10,3) // returns 720

See Also

COMBIN COMBINA PERMUT PERMUTATIONA FACT