Manuals/calci/COMBIN

COMBIN(N,R)

• $N$ is the number of items.
• $R$ is the number of items in each arrangement.

Description

• This function gives the combination of N objects.
• i.e. An arrangement of R objects without any repetition, selected from N different objects is called a combination of N objects taken R at a time.
• Also if the order is not a matter, it is a Combination.
• If order is a matter it is a Permutation.
• A combination is denoted by nCr or ${\binom {n}{r}}$.
• A formula for the number of possible combinations of R objects from a set of N objects is ${\binom {n}{r}}={\frac {n!}{r!(n-r)!}}$ where $n!=1*2*3*...*n$ & $r\leq n$.
• This function will give Error Result when
  • The N&R are non numeric
  • The N&R < 0 or N < R
• When we are giving the N&R values in decimals, it will automatically convert in to Integers.
• For e.g.
  • COMBIN(5.4,2)=10 is equivalent to COMBIN(5,2)
  • COMBIN(5,-2)=NAN, because R is negative.

Examples

COMBIN(n,r)	n	r	RESULT
COMBIN(12,3)	12	3	220
COMBIN(4,4)	4	4	1
COMBIN(4,0)	4	0	1

See Also

• FACT
• PERMUT

References

Combination