Apple iWork '09 User Manual
Page 286
Â
largest-is-high: An optional value specifying whether the smallest or the largest
value in the collection is ranked 1.
largest is low (0, FALSE, or omitted): Assign the largest value in the collection the
rank 1.
largest is high (1, or TRUE): Assign the smallest value in the collection the rank 1.
Usage Notes
Values included in the collection that are the same are ranked together, but impact
Â
the outcome.
If the specified value does not match any of the values in the collection, an error is
Â
returned.
Examples
Assume the following table contains the cumulative test scores for this semester for your 20 students.
(We have organized the data this way for the example; it would likely originally have been in 20
separate rows.)
=RANK(30, A1:E4, 1) returns 1, as 30 is the smallest cumulative test score and we chose to rank the
smallest first.
=RANK(92, A1:E4, 0) returns 2, as 92 is the second-largest cumulative test score and we chose to rank
largest first.
=RANK(91, A1:E4, 1) returns 4, as there is a “tie” for second place. The order is 100, 92, 92, then 91 and
the rank is 1, 2, 2, and then 4.
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
286
Chapter 10
Statistical Functions