 |
 |
Min Function |
 |
The next function we will discuss is Min (which stands for minimum). This will return the smallest (Min) value in the selected range of cells.
- Blank entries are not included in the calculations of the Min Function.
- Text entries are not included in the calculations of the Min Function.
| Lets use the table here for the discussion that follows. We will look at several different specific examples that show how the min functions can be used! |
|
| Example of min | Cells to look at | Ans. min |
| =min (A1:A4) | A1, A2, A3, A4 | |
| =min (A2:A3, 100) | A2, A3 and 100 | |
| =min (A1, A3) | A1, A3 | |
| =min (A1, A5) | A1, A5 (displays the smallest number) |
|
|
|
Min Function |
|
958202
|
Choose: INTEK home I training I by Jim Tracy I
|