|
<< Click to Display Table of Contents >> COMBIN (combinations) |
Syntax:
COMBIN(n, k)
Description:
Returns the number of combinations of size k in a population of size n.
In plain language: A total of n elements are available. From these a subset of exactly k elements is to be drawn. This function calculates how many different subsets there can be.
n is the total number of items. Must be > k.
k is the number of items in each combination. Must be > 0 and < n.
n and k should be integers. Digits right of the decimal point are ignored by PlanMaker.
Example:
In a lottery called "6 out of 49", 6 balls are picked out of 49 numbered balls.
How many combinations are possible?
COMBIN(49, 6) returns 13983816
There are therefore 13,983,816 possible combinations.
See also: