Special

Excel Functions

2003-2010

Special

Excel Functions

2007-2010

Lesson 20: MIN, MAX, SMALL and LARGE  Functions in Excel

The MIN functions returns the smallest value in a data set. For example:
=MIN(D2:D7) applied to the data set above should return 2

The SMALL functions returns the first or second or third... smallest value in a data set. For example:
=SMALL(D2:D7,2) applied to the data set above should return 3

So =SMALL(D2:D7,1) will return the same result as =MIN(D2:D7) .

Clean your tool box and forget about MIN now that you know that SMALL does the same as MIN and more.

The MAX functions returns the largest value in a data set. For example:
=MAX(D2:D7) applied to the data set above should return 8

The LARGE functions returns the first or second or third... smallest value in a data set. For example:
=LARGE(D2:D7,2) applied to the data set above should return 6

So =LARGE(D2:D7,1) will return the same result as =MAX(D2:D7) .

Clean your tool box and forget about MAX now that you know that LARGE does the same as MAX and more.

Excel Functions and Formulas Sitemap

Go to the next lesson:
Lesson 21: AVERAGEIF (Excel 2007)