Documentation/How Tos/Calc: COMBIN function

CALC FUNCTIONS

Mathematical Functions

< Previous Section

Next Section >

FUNCTIONS

Trigonometric

• Cos
• Sin
• Tan
• Cot
• Acos
• Acot
• Asin
• Atan
• Atan2
• Degrees
• Radians
• Pi

Hyperbolic

• Cosh
• Sinh
• Tanh
• Coth
• Acosh
• Acoth
• Asinh
• Atanh

Rounding and remainders

• Trunc
• Round
• Rounddown
• Roundup
• Ceiling
• Floor
• Even
• Odd
• Mround
• Int
• Quotient
• Mod

Logarithm/Powers

• Exp
• Power
• Log
• Ln
• Log10

Bessel functions

• Besseli
• Besselj
• Besselk
• Bessely

Miscellaneous

• Abs
• Combin
• Combina
• Convert
• Convert Add
• Countblank
• Countif
• Delta
• Erf
• Erfc
• Fact
• Factdouble
• Gcd
• Gcd Add
• Gestep
• Iseven
• Isodd
• Lcm
• Lcm Add
• Multinomial
• Product
• Rand
• Randbetween
• Seriessum
• Sign
• Sqrt
• Sqrtpi
• Subtotal
• Sum
• Sumif
• Sumsq

< Previous Page

Next Page >

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