=COMBIN(number, number_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!.