## How to use the PERMUT function

*Article updated on January 29, 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:

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.

### Articles with the 'PERMUT' Function

List permutations with repetition and how many to choose from

Noel asks: Is there a way where i can predict all possible outcomes in excel in the below example. Total […]