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 - min

The lowest value will be returned.

min - 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 - min

The lowest value will be returned.

min2 - min

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