Calculate combinations without repetition.

`COMBIN(number, number_chosen)`

- number - required argument of total number of items
- number_chosen - [OPTIONAL] argument of number of items to be chosen

`=COMBIN(8,2)`

This returns the value 28, which means that 28 two-person teams can be formed from 8 candidates.

`=COMBIN(4,3)`

This returns the value 4, which means that there are 4 possible combinations of three numbers from the set of {1, 2, 3, 4}.

`=COMBIN(3,2)/COMBIN(8,2)`

This returns the value 0.375, which means that the probability of picking two red marbles is 0.375.

The COMBIN function is used to calculate the number of combinations for a set of items. If any of the arguments are not numeric, the result will be #VALUE!.

- The COMBIN function returns the number of combinations for a given number of items, without repetitions.
- To count combinations that allow repetitions, use the COMBINA function.
- To count permutations, use the PERMUT function.

The COMBIN function is a mathematical function used to determine the total possible combinations for a given number of items. Order does not matter for combinations.

The COMBIN function takes two arguments: number and number_chosen.

The COMBIN function returns the total possible combinations for a given number of items.

The COMBIN function returns a #VALUE! error if both arguments are not numerical.

Drop CSV