Explanation

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

Practice MAX here

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 – Exercise 1

Now, let’s try to find the maximum value using MAX function:

 

Can't access the exercise? Below you can find the link to download the Excel file: 

Max-Practice.xlsx (5171 downloads )

 

Practice MAX function – Exercise 2

 

Can't access the exercise? Below you can find the link to download the Excel file: 

MAX2.xlsx (2597 downloads )

Enter our Excel Exercises Page to learn and practice MAX and other common Excel formulas!