Documentation/How Tos/Calc: COMBIN function

From Apache OpenOffice Wiki
< Documentation‎ | How Tos
Revision as of 07:21, 13 September 2008 by Drking (Talk | contribs)

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:

COMBINA, PERMUT, PERMUTATIONA

Mathematical functions

Functions listed alphabetically, Functions listed by category

Personal tools