COMBIN Function in Excel: Syntax, Examples and Free Practice
COMBIN is an Excel Statistical function. Returns the number of combinations for a set of objects.
COMBIN syntax
Arguments
number: A number to use in the calculationnumber_chosen: How many items are chosen at a time
When to use COMBIN
COMBIN is used in data analysis work to summarize or test patterns across a data set.
Practice COMBIN online, free
Open the live Excel-style spreadsheet and try COMBIN yourself. No Excel install or sign-up needed to start.
Practice COMBIN now →More Statistical functions
Frequently asked questions
What does the COMBIN function do in Excel?
Returns the number of combinations for a set of objects.
What is the syntax of COMBIN in Excel?
The syntax is =COMBIN(number, number_chosen). number: A number to use in the calculation; number_chosen: How many items are chosen at a time.
Where can I practice COMBIN online for free?
Open the free live spreadsheet on Cellgrids and try COMBIN yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Statistical functions · Excel case studies · Excel tutorials · Excel shortcuts