Spread 8.0 Documentation
MODE
Support Options
Formula Reference > Built-In Functions > MODE

Glossary Item Box

MODE


Name

Mode

Description

Returns the most frequently occurring value in a set of data.

Syntax

MODE(value1, value2, . . . )

Remarks

Accepts up to 30 arguments. Each argument can be a cell, a cell range, a float value, or an integer value.

If no value occurs more than once, the function does not return a value. If more than one value occurs the same number of times, the function returns the first value that repeats that same number of times.

See also AVERAGE, MEDIAN, and RANK.

Data Type

Accepts numeric data for all arguments. Returns numeric data. For more information, see Data Type for Each Cell Type.

Example

MODE(R1C2,12,10,R2C3)
MODE(A3,B3,C3,D3)
MODE(A1:A9)
MODE(89,95,88,97,88,74)=88
MODE(1,2,2,3,4,5,5)=2

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.