Menu
EXCEL COMBIN FUNCTION
Excel COMBIN Function Introduction
For a given number of elements, this function returns the number of possible combinations.
Description of Excel COMBIN Function
Syntax:
=COMBIN(number, number_chosen)
Parameter list:
- number – the total number of items in the group.
- The number of elements in each combination is determined by number_chosen.
Step By Step Guide of COMBIN Function
For example, if we use =COMBIN( 6, 2 ), we will receive 15 as the result because there are 15 possible combinations. There are 15 distinct combinations of two things for every six objects (e.g. a, b, c, d, e, f). These are: ab, ac, ad, ae, af, bc, bc, be, bf, cd, ce, cf, de, df, ef.
Key Points
- COMBIN returns the #VALUE! error value if any of the arguments Number or Number chosen is nonnumeric.
- If num < 0 or num_chosen < 0 or num< num_chosen COMBIN returns the #NUM! error value.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
