January 20, 2022

How to use the Excel COMBIN function

Combin function in excel is used to combine sets of a specified number. This function is categorized in mathematical trigonometry where we need to select two numbers where the first number should be greater than 0 and also it should be greater than the number is chosen and the second number which is Chosen Number it should also be greater than the first number and non-integer.

Syntax: =COMBIN(number, number_chosen)

The COMBIN function syntax has the following arguments:

• Number (required argument) – The number should either be greater than or equal to 0. Also, it should be greater than or equal to the number_chosen. Non-integer values, if entered for this parameter, are truncated.
• Number_chosen (required argument) – This is the number of items in each of the combinations. It must be greater than or equal to 0. Non-integer values are truncated.

Example: Let’s look at some Excel COMBIN function examples and explore how to use the COMBIN function as a worksheet function in Microsoft Excel: Syntax:  =COMBIN(A17,B17)

Result: Based on the Excel spreadsheet above, the following COMBIN examples would return:

Syntax: =COMBIN(A18,B18)
Result: 45

Syntax: =COMBIN(A19,B19)
Result: 1771

Syntax: =COMBIN(A20,B20)
Result: 270725

Syntax: =COMBIN(A21,B21)
Result: 5461512

Syntax: =COMBIN(A22,B22)
Result: 1192052400

Syntax: =COMBIN(A23,B23)
Result: 59487568920

READ:  How to use the Excel FACTDOUBLE function 