writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 12:
Line 12: − + − + − + − + − +
→Description
*A combination is denoted by ncr or(n r).
*A combination is denoted by ncr or(n r).
*A formula for the number of possible combinations of R objects from a set of N objects is (n r)=n!/r!(n-r)!, 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 (n r)=n!/r!(n-r)!, where n!=1*2*3*...*n& r<=n.
This function will give the result is Error when
*This function will give the result is Error when
1. The N&R are non numeric
*1. The N&R are non numeric
2. The N&R<0 or N<R
*2. 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 convert in to Integers.
*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)
*COMBIN(5,-2)=NAN, because R is negative.
*COMBIN(5,-2)=NAN, because R is negative.