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:
Based on the Excel spreadsheet above, the following COMBIN examples would return: