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.