To calculate the number of permutationswithoutrepetitions, use thePERMUT function.
A permutation is a combination where order matters.
In other words, a permutation is anorderedcombination.
There are two types of permutations:
The PERMUTATIONA function calculates permutations where repetitionsareallowed.
To calculate permutations where repetitions arenotallowed, use thePERMUT 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.
