<< Click to Display Table of Contents >> COMBIN (combinations) |
Syntax:
COMBIN(n, k)
Description:
This returns the number of combinations of size k in a population of size n.
In plain language: n items are available in total. From these, a subset of exactly k items is to be drawn. This function calculates how many different subsets there can be.
n is the total number of items. n must be > k.
k is the number of items in each combination. k must be > 0 and < n.
n and k should be integers. If this is not the case, PlanMaker automatically truncates the decimal places.
Example:
Let's consider a lottery in which 6 balls are drawn from 49 different numbered balls.
How many combinations are possible?
COMBIN(49, 6) returns 13983816
Thus, there are 13,983,816 possible combinations.
See also: