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 thePERMUTATIONA function.
The COMBIN functiondoes notallow repetitions.
To count combinations thatallowrepetitions, use theCOMBINA function.
COMBINA Function
The Excel COMBINA function returns the number of combinations with repetitionsallowed.
To count combinations thatdo notallow repetitions, use theCOMBIN function.
The PERMUT functiondoes notallow repetitions.
For example, =FACT(3) returns 6, equivalent to 3 x 2 x 1.
