Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Maths and Trigonometry > COMBIN

 

COMBIN(number, number_chosen)

 
 Returns the number of combinations for a given number of items.

 numberThe total number of items.
 number_chosenThe number of items in each combination.

 REMARKS
 
  • If any of the arguments are not numeric, then #VALUE! is returned.
     
  • If "number" is not an integer, it is truncated.
     
  • If "number" < 0, then #NUM! is returned.
     
  • If "number_chosen" is not an integer, it is truncated.
     
  • If "number_chosen" < 0, then #NUM! is returned.
     
  • If "number" < "number_chosen", then #NUM! is returned.
     
  • A combination is any set or subset of items, regardless of their internal order.
     
  • Combinations are distinct from permutations, for which the internal order is significant.
     
  • Example 1 - How many different 2 person teams can be made up from 8 people. answer 28 teams.
     
  • Example 2 - How many combinations are there for a padlock with 3 numbers, answer 1,000 possibilities.

     EXAMPLES
     
     A
    1=COMBIN(8,2) = 28
    2=COMBIN(10,1)*COMBIN(10,1)*COMBIN(10,1) = 1000
    3=COMBIN(6,2) = 15
    4=COMBIN(3,2) = 3
    5=COMBIN(2,2) = 1
    6=COMBIN("2",2) = 1
    7=COMBIN(49,6) = 13983816
    8=COMBIN(52,5) = 2598960
    9=COMBIN(2,3) = #NUM!
    10=COMBIN("some text",2) = #VALUE!
    11=COMBIN(2,"some text") = #VALUE!
     

     Functions - C | Index - C | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top