Documentation/How Tos/Calc: COMBIN function

From Apache OpenOffice Wiki
< Documentation‎ | How Tos
Revision as of 09:02, 24 November 2009 by OOoWikiBot (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.

Template:Documentation/SeeAlso

Personal tools