COMBINA

Calculates the number of ways to choose items from a set where repetitions are allowed and order doesn't matter.

Parameter List

Syntax
COMBINA(numbernumber_chosen)
number

The number of different items available to choose from. For example: 3, A1. Must be a non-negative integer.

number_chosen

The number of items to choose (with repetition allowed). For example: 2, B1. Must be a non-negative integer.

More details

COMBINA calculates combinations with repetition allowed. For example, choosing 2 items from {A,B,C} with repetition gives 6 combinations: {A,A}, {A,B}, {A,C}, {B,B}, {B,C}, {C,C}. Both arguments must be non-negative integers. Decimal portions are truncated.

Examples

COMBINA() returns 1