Formulas->Function Library->AutoSum ->MIN

Exam 77-882: Microsoft Excel 2010 Core

5. Applying Formulas and Functions

5.1. Create formulas: Use SUM, COUNT, COUNTA, AVERAGE, MIN, and MAX: MIN

 

The MIN Function

The MIN Function finds the least value in a range. In this example, the MIN will determine the smallest salary.

 

1. Try It: Use the MIN Function

Select Cell D9.

Go to Formulas ->Function Library.

Go to AutoSum.

Click on MIN.

 

Excel wrote the following equation:

=MIN(D2:D8)

This is the wrong range.

 

Use your cursor to highlight (select) Cells D2:D4.

 

2. What Do You See Now?

The correct equation is:

=MIN(D2:D4)