SheetFX
≡
<< Go back to all functions

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