next up previous contents index
Next: MODULUS, XLMOD Up: A. Function Reference Previous: MOD   Contents   Index


MODE

Syntax: MODE(argumentlist)

argumentlist = any combination of numbers, cells, or ranges

MODE returns the mode, or most frequently occurring datum, of all the arguments. Empty cells and cells containing text are ignored.

Examples:

MODE(5, 4, 10, 8, 7, 5, 4, 14, 5) = 5

MODE(A1..A7) = 2.3, where A1..A7 = 2.3, 3.4, 5.0, 3.4, 3.4, 2.3, 2.3

Excel function: MODE


next up previous contents index
Next: MODULUS, XLMOD Up: A. Function Reference Previous: MOD   Contents   Index
SpreadScript User's Guide, Version 1.2
Grey Trout Software
02 March 2003