# 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.

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

** 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.

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