 |
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
smallest number) |
10 |
1087764
info@exceltalk.net
|
