beautypg.com

272 min – Apple iWork '09 User Manual

Page 272

background image

Examples

=MEDIAN(1, 2, 3, 4, 5) returns 3.
=MEDIAN(1, 2, 3, 4, 5, 6) returns 3.5.
=MEDIAN(5, 5, 5, 5, 6) returns 5.

Related Topics
For related functions and additional information, see:

“AVERAGE” on page 231

“MODE” on page 274

“Listing of Statistical Functions” on page 225

Value Types” on page 36

The Elements of Formulas” on page 15

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

“Pasting from Examples in Help” on page 41

MIN

The MIN function returns the smallest number in a collection.

MIN(value, value…)

Â

value: A value. value can contain any value type.

Â

value…:  Optionally include one or more additional values.

Usage Notes

If

Â

value does not evaluate to a date or number, it is not included in the result.

To determine the smallest of any type of value in a collection, use the MINA

Â

function.

Examples

=MIN(5, 5, 5, 5, 6) returns 5.
=MIN(1, 2, 3, 4, 5) returns 1.

Related Topics
For related functions and additional information, see:

“LARGE” on page 264

“MAX” on page 270

272

Chapter 10

Statistical Functions