Back to Class Index
MODE(argumentlist)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 |