next up previous contents index
Next: MODULUS Up: A Function Reference Previous: MOD

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


next up previous contents index
Next: MODULUS Up: A Function Reference Previous: MOD

NExS User's Guide, Version 1.4.5
Grey Trout Software
11 April 1999