Returns the number of combinations with repetitions for a given number of items.
이 함수는 Google Sheets에서도 Excel과 동일하게 작동합니다 — 구문과 인수가 같습니다.
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)!).
=COMBINA(3, 2)결과: 6
Calculates the combinations of 2 items chosen from 3 with repetition allowed.
COMBIN calculates combinations without repetition, while COMBINA allows items to be selected more than once.