COMBIN 
COMBIN(number, number_chosen) 
Returns the number of combinations for a given number of items (without repetition). 
number  The total number of items. 
number_chosen  The number of items in each combination. 
REMARKS 
* This is also called the Binomial Coefficient. * If any of the arguments are not numeric, then #VALUE! is returned. * If "number" is not an integer, it is truncated. * If "number" < 0, then #NUM! is returned. * If "number_chosen" is not an integer, it is truncated. * If "number_chosen" < 0, then #NUM! is returned. * If "number" < "number_chosen", then #NUM! is returned. * A combination is any set or subset of items, regardless of their internal order. * Combinations are distinct from permutations, for which the internal order is significant. * This is equivalent to FACT(n)/(FACT(k)*FACT(nk)). * You can use the COMBINA function to return the number of combinations (with 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). * For the Microsoft documentation refer to support.microsoft.com * For the Google documentation refer to support.google.com 

1  How many different 2 person teams can be made up from 8 people. answer 28 teams. 2  How many combinations are there for a padlock with 3 numbers, answer 1,000 possibilities. 
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top