COMBIN

Calculates the number of ways to choose a subset of items from a larger set, where order doesn't matter.

Parameter List

Syntax
COMBIN(numbernumber_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.

Examples

COMBIN() returns 1