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
Now, let’s try to find maximum value using MAX function: