The Excel COMBIN Function

Basic Description

The Excel COMBIN function calculates the number of combinations (in any order) of a given number objects, from a set. (Note that combinations are different from permutations in that for permutations, the order of the selected objects is counted).

The format of the COMBIN function is :

COMBIN( number, number_chosen )

Where the arguments are as follows :

number - The number of objects in the set
number_chosen - The number of objects to be chosen from the set

Note that if any of the arguments are input as decimal values, they will be truncated to integers.


Excel Combin Function Examples

If we have a 6 objects (eg. a, b, c, d, e, f), there are 15 different combinations of 2 objects. These are:

ab ac ad ae af bc bd be bf cd ce cf de df ef

This is calculated using the Excel Combin function in cell A2 of the following spreadsheet. The spreadsheet also shows the Combin function used to calculate the number of combinations for other numbers of objects taken from a set of 6.

The spreadsheet on the left shows the format of the functions, and the spreadsheet on the right shows the results.

 Formula:
Examples of use of the Excel Combin Function
 Result:
Excel Combin Function Results


Further examples of the Excel Combin function can be viewed on the Microsoft Office website.


Combin Function Common Errors

If you get an error from the Excel Combin function this is likely to be one of the following :

Common Errors
#NUM! - Occurs if either :
- The supplied number argument is < 0
or
- The supplied number_chosen argument is < 0 or is greater than the number argument
#VALUE! - Occurs if either of the supplied arguments are non-numeric
Return to the Excel Math Functions Page

Return to the List of All Built-In Excel Functions

Valid XHTML 1.0 Transitional Valid CSS!
Disclaimer   Privacy Policy
Copyright © 2008-2013 ExcelFunctions.net