answersLogoWhite

0

What does COMBIN do in Excel 2010?

User Avatar

Anonymous

11y ago
Updated: 8/20/2019

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

User Avatar

Wiki User

11y ago

What else can I help you with?

Related Questions

What formula can you input into excel to come up with all the 5 number different combinations for numbers 1-39?

There is no built in function in Excel to create a list of combinations of 39 items taken 5 at a time. However, the combin function will tell you how many combinations there are. For instance, combin(39,5) = 575757.


How many number combinations in lotto 649?

5,245,786 Using MS excel input this: =COMBIN(42,6)


When was Nestor Combin born?

Nestor Combin was born on 1940-12-29.


What is the meaning of ms Excel 2010?

ms excel 2010


Can you use Excel 2010 as Excel 2007?

The differences between them are not extensive so you can work in Excel 2010 easily if you are familiar with Excel 2007. You can save your files so that Excel 2007 will recognise them.


How do you play billiards in Excel 2010?

There are no hidden games in Microsoft Excel 2010. The last version that had a hidden game was in Excel 2000. There is a game called Billiards Excel and there are Billiard 2010 games, but these have nothing to do with Microsoft Excel, or any Microsoft software.


What you learn about Excel 2010?

There is a lot to learn about Excel 2010. If you have never used any version of Excel, then a good course about it or even a good book will help. If you have used older versions of Excel, then you would not have much problem learning to use Excel 2010.


How many rows and columns in Excel 2010?

There are 1,048,576 rows and 16,384 columns in Excel 2010


What country is grand combin in?

switzerland


How can I connect tabs in Excel 2010 with information in the spreadsheet itself?

For detailed information on how to connect tabs in Excel 2010 spreadsheet visit keynotesupport.com/excel-basics/excel-linking-worksheets.shtml


What cntrl button copies in Excel 2010?

Ctrl - C will copy in Excel 2010 and in other versions.


Does installing Excel 2013 remove Excel 2010?

Not necessarily. You can have two versions of Excel on one computer.