COMBIN
Returns the number of combinations for a given number of objects.
Math & TrigonometryMath Basics
What it does
Returns the number of ways to choose k items from n items without repetition and without order.
Syntax
COMBIN(number, number_chosen)
Arguments
number(number) — Total number of items.number_chosen(number) — Number of items in each combination.
Examples
Combinations
Ways to choose 2 items from 5.
FORMULA
=COMBIN(5, 2)
RESULT
10
SAMPLE DATA
| A | B | |
|---|---|---|
| 1 | n | k |
| 2 | 5 | 2 |