writer
5,435
edits
Changes
Jump to navigation
Jump to search
Line 12:
Line 12: − + − + − +
→Description
*A formula for the number of possible combinations of <math>r</math> objects from a set of <math>n</math> 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>.
*A formula for the number of possible combinations of <math>r</math> objects from a set of <math>n</math> 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 Error Result when
*This function will give Error Result when
#The <math>n & r</math> are non numeric
#The <math>n</math> & <math>r</math> are non numeric
#The <math>n & r < 0</math> or <math>n < r</math>
#The <math>n</math> & <math>r</math> < 0 </math> or <math>n < r</math>
*When we are giving the <math>n & r</math> values in decimals, it will automatically convert in to Integers.
*When we are giving the <math>n</math> & <math>r</math> values in decimals, it will automatically convert into 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)