Difference between revisions of "Manuals/calci/COMBIN"
Jump to navigation
Jump to search
| Line 23: | Line 23: | ||
{| id="TABLE3" class="SpreadSheet blue" | {| id="TABLE3" class="SpreadSheet blue" | ||
|- class="even" | |- class="even" | ||
| − | | | + | | COMBIN(n,r) |
| − | ! | + | ! n |
| − | ! | + | ! r |
! RESULT | ! RESULT | ||
|- | |- | ||
|- class="odd" | |- class="odd" | ||
| − | | | + | |COMBIN(12,3) |
| − | | | + | |12 |
| − | | | + | |3 |
| − | | | + | |220 |
|- class="even" | |- class="even" | ||
| − | | | + | |COMBIN(4,4) |
| − | | | + | |4 |
| + | |4 | ||
|1 | |1 | ||
| − | |||
|- class="odd" | |- class="odd" | ||
| − | | | + | |COMBIN(4,0) |
| − | | | + | |4 |
| + | |0 | ||
|1 | |1 | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
|} | |} | ||
Revision as of 07:38, 15 November 2013
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 doesn't a matter, it is a combination. If order is the matter it is a permutation. A combination is dnoted 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. This function will give the result is Error when 1. The N&R are non numeric 2. The N&R<0 or N<R When we are giving the N&R values in decimals ,it will convert in to Integers.
- 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 |