This Excel tutorial explains how to use the Excel COMBIN function with syntax and examples.
chosen is the number of items in a combination.
Based on the spreadsheet above, the following Excel COMBIN examples would return:
Description
The Microsoft Excel COMBIN function returns the number of combinations for a specified number of items.Syntax
The syntax for the Microsoft Excel COMBIN function is:COMBIN( number, chosen )
Parameters or Arguments
number is the number of items.chosen is the number of items in a combination.
Applies To
The COMBIN function can be used in the following versions of Microsoft Excel:- Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000
Type of Excel Function
The COMBIN function can be used in Microsoft Excel as the following type of function:- Worksheet function (WS)
Example (as Worksheet Function)
Let's look at some Excel COMBIN function examples and explore how to use the COMBIN function as a worksheet function in Microsoft Excel:Based on the spreadsheet above, the following Excel COMBIN examples would return:
=COMBIN(A1, A2) Result: 252 =COMBIN(A1, A3) Result: 120 =COMBIN(21, 5) Result: 20349
