COMBINA Function Explained

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

COMBINA Function Syntax

COMBINA(number, number_chosen)

  • number: The total number of items from which the combination is selected.
  • number_chosen: The number of items in each combination.