COMBINA
Returns the number of combinations with repetitions for a given number of items.
Math & TrigonometryMath Basics
What it does
Returns the number of combinations (with repetitions allowed) for a given number of items.
Syntax
COMBINA(number, number_chosen)
Arguments
number(number) — Total items.number_chosen(number) — Items to choose.
Examples
Combinations with Repetition
Choose 2 from 3 with repeats allowed.
FORMULA
=COMBINA(3, 2)
RESULT
6
SAMPLE DATA
| A | B | |
|---|---|---|
| 1 | n | k |
| 2 | 3 | 2 |