Excel PERMUT Function

Using the Excel PERMUT Function


The Excel PERMUT function returns the number of permutations for a given number of items. A permutation is any set of values, objects, or events where order is important. This varies from combinations where the order is not significant. The PERMUT function could be used for lottery style probability calculations.

If order is not significant, see the COMBIN function.


=PERMUT (number, number_chosen)

Syntax Breakdown

Required. Description of the number of objects given as an integer.

Number Chosen
Required. Describes the number of objects in each permutation. Given as an integer.

Usage Notes

PERMUT returns the total possible permutations of a given number of items as an integer. Both the number and number_chosen arguments are truncated to integers if they contain decimals.

Error Values
The PERMUT function will return error values in the following scenarios:

1) #NUM! error if number < number_chosen;

2) #NUM! error if number <= 0 or if number_chosen <= 0;

3) #VALUE! error if number or number_chosen is non-numeric