COMBINA function
From Apache OpenOffice Wiki
< Documentation | How Tos
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
Trigonometric
Hyperbolic
Rounding and remainders
Logarithm/Powers
Bessel functions
Miscellaneous
COMBINA
Returns the number of combinations of a subset of items.
Syntax:
COMBINA(n; k)
- n is the number of items in the set.
- k is the number of items to choose from the set.
- COMBINA returns the number of unique ways to choose these items, where the order of choosing is irrelevant, and repetition of items is allowed. For example if there are 3 items A, B and C in a set, you can choose 2 items in 6 different ways, namely AA, AB, AC, BB, BC and CC; you can choose 3 items in 10 different ways, namely AAA, AAB, AAC, ABB, ABC, ACC, BBB, BBC, BCC, CCC.
- COMBINA implements the formula:
- (n+k-1)!/(k!(n-1)!)
Example:
COMBINA(3,2)
- returns 6.
COMBINA(3,3)
- returns 10.
See Also
