Min and Max function in excel

a) MIN Function
The MIN function in Excel, finds the lowest number in a range. Syntax =MIN(Range)

Note: • The function ignores cells with text and empty cells. It will only work for cells with numbers.
• There is another function called MAX, which finds the highest value in a range, the opposite of MIN.

Example: Let’s calculate the MIN function over the cells in the range D1:D9.

Min and Max function in Excel

The MIN function successfully returns the minimum value in the range.

Min and Max function in Excel

b) MAX Function
The MAX function in Excel, finds the highest number in a range. Syntax =MAX(Range)

Note: • The function ignores cells with text. It will only work for cells with numbers.
• There is another function called MIN, which finds the lowest value in a range, the opposite of MAX.

Example: Let’s calculate the MAX function over the cells in the range D1:D9.

Min and Max function in Excel

The MAX function successfully returns the maximum value in the range.

Min and Max function in Excel