top of page


The MAX function is employed to determine the highest value within a range of cells. 

The syntax of the MAX function is: =MAX(value1,value2,value3…)

The MIN function serves as the counterpart to the MAX function, and it is utilized to identify the minimum value within a range of cells.

The syntax of the MIN function is: =MIN(value1,value2,value3…)

bottom of page