Returns the number of combinations for a given number of items.
이 함수는 Google Sheets에서도 Excel과 동일하게 작동합니다 — 구문과 인수가 같습니다.
COMBIN(number, number_chosen)The COMBIN function calculates the total number of ways to select a subset of items from a larger set, where the order of selection does not matter. It is mathematically equivalent to the binomial coefficient formula nCr.
=COMBIN(5, 2)결과: 10
Calculates the number of ways to choose 2 items from a set of 5.
No, COMBIN calculates combinations where order is irrelevant; use PERMUT if order matters.