Documentation/Calc Functions/MODE.MULT

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

Under construction.
For now, see the system Help files.


Function name:

MODE.MULT

Category:

Statistical Analysis

Summary:

Returns a vertical array of the statistical modes (the most frequently occurring values) within a list of supplied numbers.

Syntax:

MODE.MULT(Number1; Number2; ...; Number30)

Returns:

Arguments:

Number1, Number2, ..., Number30 are numerical values or ranges.

Additional details:

As the MODE.MULT function returns an array of values, it must be entered as an array formula. If the function is not entered as an array formula, only the first mode is returned, which is the same as using the MODE.SNGL function.

Examples:

=MODE.MULT(A1:A50)

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: