Explanation
MAX function is used when we want to find the maximum value within a range of cells.
Example
Syntax
The syntax of the MAX function is as follows:
=MAX(value1,value2,value3…)
We can insert into the MAX function a range of cells, for example:
=MAX(A1:A4)
The function above will look within the cells in range A1 to A4, and return the highest value.
Practice MAX function – Execise 1
Now, let’s try to find the maximum value using MAX function:
Practice MAX function – Execise 2
Enter our Excel Exercises Page to learn and practice MAX and other common Excel formulas!