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)