COMBIN Function in Excel – Return the number of combination without repetition

The COMBIN function in Excel calculates the number of combinations of a given number objects from the set without repetition.

For any 4 objects a,b,c,d there are 6 different combination of two objects

ab ac ad bc bd cd


Syntax of COMBIN Function in Excel

COMBIN(number,number_chosen)

 

number The number of objects in the set
number_chosen The number of objects to be chosen from the set

 

Example of COMBIN Function in Excel

Formula

COMBIN Function in Excel 1

  • In Row number 2, combination of two sets has to be chosen from 4 objects (a,b,c,d). and those sets are ab, ac, ad, bc, bd and cd
  • In Row number 3 combination of two sets has to be chosen from 4 objects (a,b,c,d). and those sets are abc, abd, acd and bcd.

Similarly other combinations without repetition are calculated, so the result will be

Result

COMBIN Function in Excel 2

#NUM! Error occurs if the supplied number argument is negative.

#NUM! Error occurs if number_chosen Argument is greater than number argument.

previous COMBIN Function in Excel                                                                                                                next COMBIN Function in Excel