272 min – Apple iWork '09 User Manual
Page 272

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:
“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:
272
Chapter 10
Statistical Functions
- Numbers '09 (254 pages)
- Keynote '09 (247 pages)
- Pages '09 (279 pages)
- Boot Camp Mac OS X v10.6 Snow Leopard (18 pages)
- Boot Camp Mac OS X v10.6 Snow Leopard (19 pages)
- Mac OS X v10.6 Snow Leopard (7 pages)
- GarageBand '08 (102 pages)
- iDVD '08 (35 pages)
- GarageBand '09 (122 pages)
- iWeb (37 pages)
- iMovie '08 (50 pages)
- Boot Camp (Mac OS X v10.5 Leopard) (25 pages)
- Boot Camp (Mac OS X v10.5 Leopard) (27 pages)
- Mac OS X v10.5 Leopard (16 pages)
- Mac OS X (622 pages)
- Mac OS X Server (Version 10.6 Snow Leopard) (197 pages)
- Mac OS (42 pages)
- Mac OS X Server (Upgrading and Migrating For Version 10.4 or Later) (97 pages)
- iMovie HD (83 pages)
- iMovie HD (47 pages)
- MAC OS 7.6.1 (4 pages)
- Mac OS X Server (Extending Your Wiki Server For Version 10.5 Leopard) (45 pages)
- Mac OS X Server Ver 10.4 (35 pages)
- Mac OS X Server v10.6 (76 pages)
- Mac OS X Server v10.6 (97 pages)
- Macintosh Japanese Language Kit (30 pages)
- Xserve (Early 2008) DIY Procedure for Hard Drive (3 pages)
- Xserve (8 pages)
- Xserve (60 pages)
- GarageBand 3 (98 pages)
- Remote Desktop 3.1 (191 pages)
- Motion 5.1.1 (1090 pages)
- Workgroup Server 8150/110 (144 pages)
- Aperture (476 pages)
- Xserve Intel (Late 2006) DIY Procedure for Optical Drive Cable (7 pages)
- Xserve Intel (Late 2006) DIY Procedure for Optical Drive Cable (6 pages)
- Network Services Location Manager Network (8 pages)
- Macintosh System 7.5 (65 pages)
- Macintosh System 7.5 (126 pages)
- Macintosh System 7.5 (114 pages)
- DVD Studio Pro 4 (656 pages)
- Keynote '08 (204 pages)
- Xsan 2 (Second Edition) (11 pages)
- LiveType 2 (157 pages)