COMBINA

The COMBINA function in Google Sheets returns the number of ways to choose some number of objects from a pool of a given size of objects, including ways that choose the same object multiple times.

Function Syntax and Parameters

Syntax: COMBINA(n, k)

Parameters:

• n: The size of the pool of objects.
• k: The number of objects to choose.

Step-by-Step Tutorial

1. Using COMBINA for choosing objects:

   • Example: =COMBINA(5, 3)
   • Result: 35

2. Using COMBINA with different values:

   • Example: =COMBINA(8, 2)
   • Result: 36

Use Cases and Scenarios

1. Probability Calculation: Calculate the number of possible outcomes in a certain event.
2. Permutations with Repetition: Determine the number of different arrangements with repetition.

Related Articles

• Top 4 Basic Math Functions Every Google Sheets User Should Know
• 10 Essential Google Sheets Formulas Every User Should Know