 |
The next function we will discuss is Max (which stand for Maximum).
This will return the largest (max) value in the selected range of cells.
- Blank entries are not included in the calculations of the Max
Function.
- Text entries are not included in the calculations of the Max
Function.
Let's use the table here for the discussion that follows.
We
will look at several different specific examples that show how the Max
functions can be used! |
|
A |
| 1 |
10 |
| 2 |
20 |
| 3 |
30 |
| 4 |
test |
| 5 |
|
|
| Example of Max | Cells to look
at | Ans. Max |
| =max (A1:A4) | A1, A2, A3, A4 |
30 |
| =max (A1:A4, 100) | A1, A2, A3, A4 and
100 |
100 |
| =max (A1, A3) | A1, A3 |
30 |
| =max (A1, A5) | A1, A5 |
10 |
1197680
info@exceltalk.net
|
