Parameter List
Syntax
COMBIN(number, number_chosen)
number
The total number of items. For example: 10
, A1
. Must be a non-negative integer ≥ number_chosen.
number_chosen
The number of items to choose from the total. For example: 3
, B1
. Must be a non-negative integer ≤ number.
More details
COMBIN calculates combinations without repetition, where order doesn't matter. For example, choosing 2 items from {A,B,C} gives 3 combinations: {A,B}, {A,C}, {B,C}. Both arguments must be non-negative integers, and number_chosen must be ≤ number. Decimal portions are truncated.