Mode, Month – Apple Numbers '08 User Manual

Page 251

Advertising
background image

Chapter 12

Dictionary of Functions

251

MODE

The MODE function finds the most frequently occurring value in a set of numbers.

MODE(number, [number, . . .])

 number: A set of numbers, numeric expressions, or references to cells containing

numbers or numeric expressions.

Notes
If more than one number occurs multiple times in the arguments, MODE returns the
first qualifying number.

If no value occurs more than once, MODE reports an error.

MONTH

The MONTH function extracts the month number from a date.

MONTH(date)

 date-time: Any valid Numbers date.

Examples

MOD(6, 3) returns 0.

MOD(7, 3) returns 1.

MOD(8, 3) returns 2.

MOD(-8, 3) returns 1.

MOD(4.5, 2) returns 0.5.

MOD(7, 0.75) returns 0.25.

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.

Examples

MONTH("April 6, 1988 11:59:22 AM") returns 4.

Advertising