COMBIN Function Explained

The COMBIN function in Microsoft Excel calculates the number of combinations for a given number of objects. It takes two arguments: number and number_chosen. number is the total number of objects, and number_chosen is the number of objects in each combination. The result is the number of combinations that can be made from the given number of objects, taken number_chosen at a time.

COMBIN Function Syntax

COMBIN(number, number_chosen)

  • number: The total number of items.
  • number_chosen: The number of items in each combination.