Article updated on April 20, 2018

The PERMUT function returns the number of permutations for a set of elements that can be selected from a larger number of elements. The internal order of the elements is important in permutations.

Formula in cell F3:

=PERMUT(3,2)

Column B, C and D demonstrate how many permutations there are when 2 elements are selected out of 3 elements [A, B, C].

The six permutations are [A,B] ,[A,C] ,[B,C] , [B,A] , [C,B] and [C,A].

Excel Function Syntax

PERMUT(number, number_chosen)

Arguments

number Required. A whole number larger than 0 (zero) that represents the total number of elements.
number_chosen Required. A whole number larger than 0 (zero) that represents the number of elements in each permutation.

Comments

I recommend you click on the following link if you want to read about the difference between combinations and permutations in greater detail.