COMBINA

COMBINA(number, number_chosen)

Returns the number of combinations for a given number of items (with repetition).

numberThe total number of items.
number_chosenThe number of items in each combination.

REMARKS
* This is also called the Binomial Coefficient.
* If "number" < 0, then #NUM is returned.
* If "number" < "number_chosen", then #NUM is returned.
* If "number_chosen" < 0, then #NUM is returned.
* If "number" is not an integer, it is truncated.
* If "number_chosen" is not an integer, it is truncated.
* You can use the COMBIN function to return the number of combinations (without repetition)
* You can use the FACT function to return the factorial of a positive whole number.
* You can use the MULTINOMIAL function to return the number of permutations for a given number of items (with duplicates).
* This function was added in Excel 2013.
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com

 A
1=COMBINA(1,1) = 1 = a
2=COMBINA(2,2) = 3 = ab, aa, bb
3=COMBINA(3,2) = 6 = ab, bc, ac, aa, bb, cc
4=COMBINA(4,2) = 10 = ab, bc, cd, dc, ad, bd, ad, aa, bb, cc, dd
5=COMBINA(5, 2) = 15
6=COMBINA(6, 2) = 21
7=COMBINA(7, 2) = 28
8=COMBINA(8, 2) = 36
9=COMBINA(10, 1)*COMBINA(10, 1)*COMBINA(10, 1) = 1000
10=COMBINA("8", "4") = 330
11=COMBINA(1, 2) = 1
12=COMBINA("some text", 2) = #VALUE!
13=COMBINA(2, "some text") = #VALUE!


© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top