This Excel tutorial explains how to use the Excel COMBINA function with syntax and examples.
chosen is the number of items in a combination. It can not be a negative value. If a non-integer value is entered for this parameter, the COMBINA function will truncate the value.
Based on the spreadsheet above, the following Excel COMBINA examples would return:
Description
The Microsoft Excel COMBINA function returns the number of combinations for a specified number of items and includes repetitions.Syntax
The syntax for the Microsoft Excel COMBINA function is:COMBINA( number, chosen )
Parameters or Arguments
number is the number of items represented as an integer. It can not be a negative value and it must be greater than or equal to chosen. If a non-integer value is entered for this parameter, the COMBINA function will truncate the value.chosen is the number of items in a combination. It can not be a negative value. If a non-integer value is entered for this parameter, the COMBINA function will truncate the value.
Applies To
The COMBINA function can be used in the following versions of Microsoft Excel:- Excel 2013
Type of Excel Function
The COMBINA function can be used in Microsoft Excel as the following type of function:- Worksheet function (WS)
Example (as Worksheet Function)
Let's look at some Excel COMBINA function examples and explore how to use the COMBINA function as a worksheet function in Microsoft Excel:Based on the spreadsheet above, the following Excel COMBINA examples would return:
=COMBINA(A1, A2) Result: 2002 =COMBINA(A1, A3) Result: 220 =COMBINA(21, 5) Result: 53130
