Formualizer Docs
ReferenceFunctionsMath Functions

COMBINA

Returns the number of combinations with repetition.

Summary

Returns the number of combinations with repetition.

Examples

Choose with repetition
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
20

FAQ

How is COMBINA different from COMBIN?

COMBINA counts selections where the same item can be chosen more than once.

Runtime metadata

Category

Math

Signature

COMBINA(arg1: Number, arg2: Number)

Arity

min 2, max 2

Arguments

arg1

Number · Scalar · coercion NumberLenientText

arg2

Number · Scalar · coercion NumberLenientText

Caps

PURE

Source

crates/formualizer-eval/src/builtins/math/combinatorics.rs

COMBIN

Returns the number of combinations for selecting `k` items from `n`.

COS

Returns the cosine of an angle in radians.

On this page

SummaryExamplesRelated functionsFAQHow is COMBINA different from COMBIN?Runtime metadata