|
Excel: A Question of Balance
The MIN
Function finds the least value in a range. In this example, the MIN will
determine
the smallest salary. Try It: Use
the MIN Function Select Cell
D10. Go to
Formulas -> 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.
What Do You
See Now?
The correct
equation is:
=MIN(D2:D4)
|
||||
|
| ||||
Microsoft Excel 2007 Exam 77-602 Topic: 3. Creating and Modifying Formulas
3.2. Summarize data using a formula 3.2.1. Use SUM, COUNT, COUNTA, AVERAGE, MIN, and MAX