Back to Functions

COMBIN

Returns the number of ways to choose some number of objects from a pool of a given size of objects.

MathCOMBIN(n, k)

COMBIN

The COMBIN function in Google Sheets returns the number of ways to choose some number of objects from a pool of a given size of objects. This function is commonly used in mathematics and statistics.

Function Syntax and Parameters

Syntax: COMBIN(n, k)

Parameters:

  • n: The total number of items in the pool.
  • k: The number of items to choose.

Step-by-Step Tutorial

To use the COMBIN function:

  1. Insert the values for n and k in the function syntax.
    • Example: =COMBIN(10, 3)
    • Result: 120

Use Cases and Scenarios

Some of the use cases for the COMBIN function are:

  1. Probability Calculations: Calculate the number of combinations in a card game or lottery.
  2. Mathematical Analysis: Count the number of ways to select a committee from a group of candidates.

Related Functions

There are no directly related functions to COMBIN.

Related Articles

There are no related articles for the COMBIN function.

Newsletter

More COMBIN examples coming soon.

We are building short, practical updates for Sheets power users.