Spread 8.0 Documentation
COMBIN
Support Options
Formula Reference > Built-In Functions > COMBIN

Glossary Item Box

COMBIN


Name

Combination

Description

Returns the number of possible combinations for a specified number of items.

Syntax

COMBIN(value1, value2)

Remarks

Specify the number of items using the value1 argument. Specify the number of items in each possible combination using the value2 argument. Both arguments must be positive integers, and the value1 argument must be greater than or equal to the value2 argument.

A combination is any set or subset of items, regardless of the internal order of the items. Contrast with permutation (the PERMUT function).

The number of combinations is calculated as follows, where value1=n and value2=k:

where:

See also PERMUT.

Data Type

Accepts numeric data for both arguments. Returns numeric data. For more information, see Data Type for Each Cell Type.

Example

COMBIN(R1C2,2)
COMBIN(C4,B2)
COMBIN(B3,5)
COMBIN(8,2)=28
COMBIN(100,3)=161700

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.