Owner manual

“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26

“Pasting from Examples in Help” on page 41

MODE

The MODE function returns the most frequently occurring value in a collection of

numbers.

MODE(num-date-dur, num-date-dur…)

Â num-date-dur: A value. num-date-dur is a number value, a date/time value, or a

duration value.

Â num-date-dur…:Optionally include one or more additional values. If more than

one num-date-dur value is specied, all must be of the same type.

Usage Notes

If more than one number occurs the maximum multiple times in the arguments, Â

MODE returns the rst such number.

If no value occurs more than once, the function returns an error. Â

Examples

=MODE(5, 5, 5, 5, 6) returns 5.

=MODE(1, 2, 3, 4, 5) returns an error.

=MODE(2, 2, 4, 6, 6) returns 2.

=MODE(6, 6, 4, 2, 2) returns 6.