Manuals/calci/COMBIN
Syntax
Remarks
Examples
''''''' ''''
Description
COMBIN
COMBIN (N, M)
Where N is the no. of items and M is the no. of items in the arrangement.
· COMBIN calculates an error value when the argument is nonnumeric.
· The number of combinations is as follows, where N(no. of items) = n and M(no. of items in the arrangement) = k:
Formula:-
It calculates the number of combinations for the known items.
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 35 | 8 | ||
| Row2 | 23535820 | |||
| Row3 | ||||
| Row4 | ||||
| Row5 | ||||
| Row6 |
Lets see an example in (Column1, Row 1 and Column 2, Row2)
COMBIN (A, B)
COMBIN (C1R1, C2R1)'
That is COMBIN (35, 8) is 23535820