Excel function MIN

The MIN function returns the lowest value in a series of numbers.

1st method

Select the MIN function. In the "Number1" field, enter a data range and then click OK.

min function

The lowest value will be returned.

min

2nd method

Select the MIN function. Enter one cell in each box (up to 255 boxes will be added automatically) and then click OK.

min function2

The lowest value will be returned.

min2 min

The 2nd method is generally used when the numbers are dispersed on the sheet.