writer
5,435
edits
Changes
Jump to navigation
Jump to search
Line 10:
Line 10: − + − + − + − + − +
→Description
*If order is a matter it is a Permutation.
*If order is a matter it is a Permutation.
*A combination is denoted by nCr or <math>\binom{n}{r}</math>.
*A combination is denoted by nCr or <math>\binom{n}{r}</math>.
*A formula for the number of possible combinations of R objects from a set of N objects is <math>\binom{n}{r}=\frac{n!}{r!(n-r)!}</math> where n!=1*2*3*...*n& r<=n.
*A formula for the number of possible combinations of R objects from a set of N objects is <math>\binom{n}{r}=\frac{n!}{r!(n-r)!}</math> where <math>n!=1*2*3*...*n </math>& <math>r \le n</math>.
*This function will give the result is Error when
*This function will give Error Result when
*1.The N&R are non numeric
**The N&R are non numeric
*2.The N&R<0 or N<R
**The N&R < 0 or N < R
*When we are giving the N&R values in decimals ,it will convert in to Integers.
*When we are giving the N&R values in decimals, it will automatically convert in to Integers.
*For e.g.
*For e.g.
**COMBIN(5.4,2)=10 is equivalent to COMBIN(5,2)
**COMBIN(5.4,2)=10 is equivalent to COMBIN(5,2)