COMBIN

The COMBIN function returns the number of combinations without repetition of a set of elements grouped in blocks of a certain size.

Syntax

COMBIN(
    number,
    number_chosen
)

Parameters
  • number: Number of elements to group.
  • number_chosen: Number of elements considered in each combination.
Returned value

The COMBIN function returns an integer.

Additional Information

If the number or number_chosen arguments are not integers, they will be rounded to the nearest integer. If they are not numbers or are negative numbers, the function will return an error (both arguments can be 0, in which case the result will be 1). number must be greater than or equal to number_chosen. Otherwise an error message will be returned.

A combination of N elements grouped in blocks of K elements without repetition is a subset of K elements, all different, in which their order is not taken into account.

Examples

The number of combinations of 4 elements (A, B, C, D) grouped in blocks of 3 without repetition is 3:

  • A, B, C
  • A, B, D
  • A, C, D
  • B, C, D

COMBIN function. Example of use

 

Related functions
Category
Mathematical and trigonometric
Submitted by admin on Tue, 12/04/2018 - 12:41