Microsoft Office Tutorials and References

In Depth Information

l
The Function Arguments

dialog box appears for

the
LARGE
function.

6

Click and drag to select

the cells you want to

evaluate, or type the

range.

7

6

Type a number

indicating what you are

seeking: 1 for highest, 2

for second highest, 3 for

third highest, and so on.

7

8

8

Click OK.

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

instead.

Apply It!

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

39