EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources Maths Function in Excel COMBIN Function in Excel
Secondary Sidebar
Excel Functions
  • Maths Function in Excel
    • Calculating Investment Return In Excel
    • Sumif Function Examples
    • MROUND in Excel
    • SUM Cells in Excel
    • MMULT in Excel
    • MINVERSE in Excel
    • Trunc in Excel
    • SUMIF with Text
    • COS Function in Excel
    • RANDBETWEEN in Excel
    • Excel SUMIF with OR
    • Excel DEGREES Function
    • Calculations in Excel
    • Sumif Between Two Dates
    • Calculate Income Tax in Excel
    • PRODUCT Function in Excel
    • How to Sum Multiple Rows in Excel
    • Matrix in Excel
    • ROUND Formula in Excel
    • How to SUM in Excel
    • SUMPRODUCT Formula in Excel
    • Excel Running Total
    • Excel Rounding
    • Excel Exponents
    • Excel SIN Function
    • Excel Square Root Function
    • Excel ROUNDUP Function
    • ROUND Excel Function
    • Excel ROUNDDOWN Function
    • ODD Excel Function
    • SUMPRODUCT Function in Excel
    • AGGREGATE Function in Excel
    • ABS Function in Excel
    • Excel TAN Function
    • COMBIN Function in Excel
    • CEILING Function in Excel
    • INT Excel Function
    • SUBTOTAL Function in Excel
    • LN Function in Excel
    • Excel RAND Function
    • TANH Function in Excel
    • SUMIF Function in Excel
    • SUM Function in Excel
    • POWER Function in Excel
    • EVEN Function in Excel
    • LOG Function in Excel
    • FLOOR Excel Function
  • Excel Functions (12+)
  • Excel Tools (114+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Lookup Reference Functions in Excel (35+)
  • TEXT and String Functions in Excel (26+)
  • Date and Time Function in Excel (24+)
  • Statistical Functions in Excel (59+)
  • Information Functions in Excel (4+)
  • Excel Charts (56+)
  • Excel Tips (222+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (22+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • Online EXCEL ADVANCED Certification
  • Excel for HR Training

COMBIN Function in Excel

By Pradeep SPradeep S

COMBIN Function in Excel

COMBIN Function in Excel (Table of Contents)

  • COMBIN in Excel
  • How to use the COMBIN Function in Excel?

COMBIN in Excel

Combin function in excel is used to combine sets of a specified number. This function is categorized in mathematical trigonometry where we need to select two numbers where the first number should be greater than 0, and also it should be greater than the number is chosen, and the second number, which is Chosen Number it should also be greater than the first number and non-integer.

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

COMBIN Formula in Excel:

Below is the COMBIN Formula in Excel.

All in One Excel VBA Bundle(120+ Courses, 30+ Projects)
Basic ExcelAdvanced ExcelVBA & MacrosExcel Dashboards
Pivot TablesStatistical FunctionsFinancial FunctionsCharts & Graphs
Price
View Courses
120+ Online Courses | 30+ Projects | 500+ Hours | Verifiable Certificates | Lifetime Access
4.9 (64,368 ratings)

COMBIN Formula in Excel

Where both the arguments are compulsory parameters, it needs to be entered to get the desired result.

  • Number or n: It is a number of items, or it is a number of objects in the set

Note: It should be equal or greater than the number_chosen.

  •  Number_chosen or k: It is the number of items in a combination of It is a number of items in each of the combinations

How to Use the COMBIN Function in Excel?

COMBIN Function in Excel can be used as a worksheet function as well as a VBA Function. Here are some examples of the COMBIN function to understand the working of the COMBIN function in Excel.

You can download this COMBIN Function Excel Template here – COMBIN Function Excel Template

Example #1

Suppose I have six items, i.e. K, L, M, N, O, P. I want in a combination of 2. Here I want to know the combinations of two-letter that are possible from a list (K, L, M, N, O, P). It can be calculated easily by the COMBIN formula.

Select the cell D10 where the COMBIN function needs to be applied.

Example 1-1

Click the insert function button (fx) under the formula toolbar, a dialog box will appear, type the keyword “COMBIN” in the search for a function box, COMBIN function will appear in select a function box. Double click on the COMBIN function.

COMBIN Example 1-2

A dialog box appears where arguments (number & number_chosen) for the COMBIN function need to be filled or entered.

Function Arguments Example 1-3

Here number argument is 6, Whereas the number_chosen value is 2.

i.e. =COMBIN(6,2)is used to find out the possible number of combinations.

COMBIN Example 1-4

It results or returns the value of 15.

COMBIN Example 1-5

15 below mentioned combination is possible.

COMBIN Example 1-6

Here, elements internal order is not important; that’s why [K, L] and [L, K] are the same combination. Now let’s use the COMBIN formula in excel to find out the number of combinations without repetitions for the other numbers of objects taken from a set of 6.

COMBIN Example 1-7

Example #2

I have numbers from 1 to 7 in the excel sheet. i.e. 1, 2, 3, 4, 5, 6, 7. I want in a combination of 2. Here I want to know the combinations of two-digit that are possible from a list (1, 2, 3, 4, 5, 6, 7). It can be calculated easily by the COMBIN formula.

Select the cell D7 where the COMBIN function needs to be applied.

Example 2-1

Click the insert function button (fx) under the formula toolbar, a dialog box will appear, type the keyword “COMBIN” in the search for a function box, COMBIN function will appear in select a function box. Double click on the COMBIN function.

COMBIN Example 2-2

A dialog box appears where arguments (number & number_chosen) for the COMBIN function need to be filled or entered.

COMBIN Example 2-3

Here number argument is 7, Whereas the number_chosen value is 2.

i.e. =COMBIN(7,2) is used to find out the possible number of combinations.

Function Arguments Example 2-4

It results or returns the value 21.

COMBIN Example 2-5

21 below mentioned combination is possible.

COMBIN Example 2-6

Here, numbers internal order is not important; that’s why [1,2] and [2,1] are the same combination. Now let’s use the COMBIN formula in excel to find out the number of combinations without repetitions for the other numbers of objects taken from a set of 7.

COMBIN Example 2-7

Example #3

In this example, I need to find out how many teams are possible in a group of three from nine players?. I have the total number of players here. i.e. 9. I want in a combination of 3. Here I want to know the combinations of three-digit that are possible from 9 players. It can be calculated easily by the COMBIN formula.

Select a cell “C9” where the COMBIN function is applied.

Example 3-1

From the Math & Trig Functions menu, select COMBIN to open its Function Arguments dialog box.

COMBIN Example 3-2

In the Function Arguments dialog box, type the appropriate values for the arguments.

Function Arguments Example 3-3

In the Number argument, enter 9. In the Number_chosen argument, enter 3.

i.e. =COMBIN(9,3)

COMBIN Example 3-4

With values entered for both arguments, answer 84 appears in the dialog box.

COMBIN Example 3-5

Things to remember about the COMBIN Function in Excel

  • Note that if any of the arguments, i.e. (number, number_chosen) in COMBIN function are supplied as decimal values, they are truncated to integers by the COMBIN function.
  • In Combin function,COMBIN (number, number_chosen), if number & number_chosen argument are NON-NUMERIC VALUE, then COMBIN function will return #VALUE! Error.
  • #NUM error occurs if the supplied number argument is less than 0 or negative value or if a chosen argument is less than 0 or is greater than the number argument.

E.G 

=COMBIN (-1,2) = #NUM!

=COMBIN (1,2) = #NUM!

=COMBIN(“TEXT”,2) = #VALUE!

=COMBIN(2,”TEXT”) = #VALUE!

  • If either of the argument, i.e. number_chosen or number argument in combin function, is less than 0, then the COMBIN function will return the #NUM! Error.
  • Excel COMBIN and COMBIN function both calculate a number of possible combinations of a set of objects or a number of items. The only difference between these functions is COMBIN function counts repetitions of combinations, whereas the COMBIN function does not count a repetition.

Example:

In a set of 3 objects, X, Y, Z. how many combinations of 2 objects are there?. The Combin function returns the result 3 (combinations: XY, XZ, YZ);

Whereas, The COMBIN function returns the result 6 (combinations: XX, XY, XZ, YY, YZ, ZZ)

  • A combination is any subset of items or set, regardless of their internal order. Combinations differ from permutations; in permutations, the internal order is significant.
  • In the COMBIN function, an internal order is not important.

Recommended Articles

This has been a guide to COMBIN in Excel. Here we discuss the COMBIN Formula in Excel and How to use COMBIN Function in Excel along with practical examples and downloadable excel template. You can also go through our other suggested articles –

  1. XIRR in Excel
  2. NOT in Excel
  3. TRANSPOSE in Excel
  4. AND Function in Excel
Popular Course in this category
Excel Advanced Training (16 Courses, 23+ Projects)
  16 Online Courses |  23 Hands-on Projects |  140+ Hours |  Verifiable Certificate of Completion
4.8
Price

View Course

Related Courses

Excel for HR Training (8 Courses, 10+ Projects)4.9
0 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2022 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download COMBIN Function Excel Template

EDUCBA

Download COMBIN Function Excel Template

EDUCBA

डाउनलोड COMBIN Function Excel Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more