The COMBINA function in Excel calculates the number of combinations of a given number objects from the set with repetition.
For any 4 objects a,b,c,d there are 10 different combination of two objects
Syntax of COMBINA Function in Excel
|number||The number of objects in the set|
|number_chosen||The number of objects to be chosen from the set|
Example of COMBINA Function in Excel
- 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, cd, aa, bb, cc, and dd.
Similarly other combinations with repetition are calculated, so the result will be
#NUM! Error occurs if the supplied number argument is negative.
#NUM! Error occurs if number_chosen Argument is greater than number argument.