Changes

Jump to navigation Jump to search
no edit summary
Line 1: Line 1: −
<div style="font-size:30px">'''COMBIN(n,r)'''</div><br/>
+
<div style="font-size:30px">'''COMBIN(N,R)'''</div><br/>
    
*'N' is the number of items.
 
*'N' is the number of items.
Line 5: Line 5:     
==Description==
 
==Description==
This function gives the combination of N objects.  
+
*This function gives the combination of N objects.  
i.e.An arrangement of R objects without any repetition,
+
*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.
+
*selected from N different objects is called a combination of N objects taken  R at a time.
Also if the order doesn't a matter, it is a combination.  
+
*Also if the order doesn't a matter, it is a combination.  
If order is the matter it is a permutation.
+
*If order is the matter it is a permutation.
A combination is dnoted 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
writer
6,694

edits

Navigation menu