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.
Let's 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! |
|
A
|
| 1 |
10
|
| 2 |
20
|
| 3 |
30
|
| 4 |
test
|
| 5 |
|
|
| Example of min | Cells to look at | Ans. min |
| =min (A1:A4) | A1, A2, A3, A4 |
10
|
| =min (A2:A3, 100) | A2, A3 and 100 |
20
|
| =min (A1, A3) | A1, A3 |
10
|
| =min (A1, A5) | A1, A5 (displays the smallestnumber) |
10
|
