SheetFX
≡
<< Go back to all functions

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.