by 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
