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.