Google Sheets-functie

COMBINA

Returns the number of combinations with repetitions for a given number of items.

Formule genereren met AI Dezelfde functie in Excel

Deze functie werkt in Google Spreadsheets hetzelfde als in Excel — dezelfde syntaxis en argumenten.

Syntaxis

COMBINA(number, number_chosen)

The COMBINA function calculates the total number of ways to choose a specified number of items from a set, where the order does not matter and items can be selected more than once. It is mathematically equivalent to the combination with repetition formula (n+k-1)! / (k!(n-1)!).

Argumenten

numbervereistThe total number of items to choose from, must be greater than or equal to 0.
number_chosenvereistThe number of items to choose, must be greater than or equal to 0.

Voorbeelden

=COMBINA(3, 2)

Resultaat: 6

Calculates the combinations of 2 items chosen from 3 with repetition allowed.

Veelgestelde vragen

What is the difference between COMBIN and COMBINA?

COMBIN calculates combinations without repetition, while COMBINA allows items to be selected more than once.

Gerelateerde functies

COMBIN PERMUT FACT