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

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