A combination is a group of items where orderdoes notmatter.
The COMBIN functiondoes notallow repetitions.
To count combinations thatallowrepetitions, use theCOMBINA function.
To countpermutations(combinations where order does matter) see thePERMUT function.
This result can be seen in cell D8 in the example shown.
The COMBIN function takes two arguments:number, andnumber_chosen.Numberis the number of different items available to choose from.
Thenumber_chosenargument is the number of items in each combination.
Both arguments are required.
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.
