- Picture and text skills
- Case
Calculate the number of combinations of several objects extracted from a given number of object collections. Use the function COMBIN to determine the number of possible combinations of a set of objects.
Syntax
COMBIN(number,number_chosen)
Number is the total number of objects.
Number chosen is the number of objects in each combination quantity.
Description
• If the numeric parameter is a non-integer, it will be truncated.
• If the parameter is a non-numeric type, then Function COMBIN returns the error value #VALUE!.
• If number < 0, number_chosen< 0 or number < number_chosen, COMBIN returns the error value #NUM!.
• Regardless of their internal order, the composition of objects is Any collection or subset of an object as a whole. Combination is different from permutation. The number of permutations is related to the internal order of the object.
Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/shu-xue-he-san-jiao-han-shu-qiao-yong-COMBIN-han-shu-qiu-zu-he-shu.html
评论列表(196条)
测试