Formula Engine Reference Guide
 

 

Back to Class Index

 

MODE(argumentlist)

Description
This function returns the mode, or most frequently occurring datum, of all the arguments. Empty cells and cells containing text are ignored.
 
Parameters
argumentlist

Any combination of numbers, cells, or ranges
 
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