Returns the number of combinations with repetitions for a given number of items.
الصيغة
COMBINA(number, number_chosen)المعاملات
numberمطلوب
The total number of items to choose from, must be greater than or equal to 0.
number_chosenمطلوب
The number of items to choose, must be greater than or equal to 0.
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)!).
=COMBINA(3, 2)→6Calculates the combinations of 2 items chosen from 3 with repetition allowed.
Select a cell
Click on the cell where you want to display the result.
Enter the formula
Type =COMBINA(number, number_chosen) and replace the arguments with your values.
Press Enter
Press Enter to calculate the number of combinations.
COMBIN calculates combinations without repetition, while COMBINA allows items to be selected more than once.