MAX function is used when we want to find the maximum value within a range of cells.

Practice MAX here




The syntax of the MAX function is as follows:


We can insert into the MAX function a range of cells, for example:


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!

Having an issue with the formulas' language? check out this post