COMBIN()
Syntax. COMBIN(number,number_chosen)
Definition. This function returns the number of combinations for a given number of elements.
Arguments
number (required) The number of elements
number_chosen (required) The number of elements in each combination
Background. Use the COMBIN() function to determine the total possible number of groups for a given number of elements.
A combination is any set or subset of elements. Combinations are distinct from permutations (see the PERMUT() function in Chapter 12) for which the internal order is significant. This means that ABC equals BCA or CAB.
Because the COMBIN() function uses only values without decimal points, the numeric values are truncated to integers. If one of the arguments isn’t a numeric expression, ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
