Microsoft Office Tutorials and References
In Depth Information
l The Function Arguments
dialog box appears for
the LARGE function.
Click and drag to select
the cells you want to
evaluate, or type the
Type a number
indicating what you are
seeking: 1 for highest, 2
for second highest, 3 for
third highest, and so on.
l The cell displays the value you requested.
If K in Step 7 is greater than the number
of cells, a #NUM error appears in the cell
To add the top three or other highest values in a
series, you can use LARGE three times in a formula:
=LARGE(Sales,3) + LARGE(Sales,2) +
LARGE(Sales,1) , with Sales being the named
range of sales values.
Did You Know?
Other useful functions work in a similar manner to
the LARGE function. SMALL evaluates a range of
values and returns a number. For example, if you
enter 1 as the K value, it returns the lowest number,
2 for next lowest, and so on. The MIN and MAX
functions return the lowest and highest values in a
series, respectively. They take one argument: a range
of cell values.
Chapter 2: Work with Formulas and Functions