Documentation/How Tos/Calc: COMBIN function

From Apache OpenOffice Wiki
Jump to: navigation, search



COMBIN

Returns the number of combinations of a subset of items.

Syntax:

COMBIN(n; k)

n is the number of items in the set.
k is the number of items to choose from the set.
COMBIN returns the number of ways to choose these items. For example if there are 3 items A, B and C in a set, you can choose 2 items in 3 different ways, namely AB, AC and BC.
COMBIN implements the formula:
n!/(k!(n-k)!)

Example:

COMBIN(3,2)

returns 3.



See Also
Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/How_Tos/Calc:_COMBIN_function&oldid=243369"
Views
Personal tools
Navigation
Tools