Parameter List
Syntax
COMBINA(number, number_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.