What does COMBIN do in Excel 2010?

Answer 1

It gives you the amounts of combinations of numbers from a set of numbers. For example if you wanted to find how many combinations of 2 numbers can you get from 6 numbers you would do this:

=COMBIN(6,2)

It will give the result 15, because there are 15 combinations as follows, where we are getting combinations of 2 numbers from the numbers 1 to 6:

1,2

1,3

1,4

1,5

1,6

2,3

2,4

2,5

2,6

3,4

3,5

3,6

4,5

4,6

5,6