September 17, 2021

# How to use min function in excel

Min function will be used to search for the smallest value in a data range, maybe a whole worksheet or only a certain range of data. How to use the Min function in Excel is guided in the following article.

Syntax: =MIN(number1, [number2], …)

The MIN function syntax has the following arguments:

• number1 – the first number from a set of values from which you want to get the minimum value.
• [number2], .. – (optional) second number from a set of values from which you want to get the minimum value. Up to 255 arguments can be used in the MIN function.

MIN in Excel Example: 1.1 For example, to get the smallest value in the range C17:C24, use this simple formula:

Syntax: =MIN(C17:C24)

Result: 1.2 For example, to get the smallest value in the range D18,D20,D22,D24, use this simple formula:

Syntax: =MIN(D18,D20,D22,D24)

Result: 1.3 For example, to get the smallest value in the range C17:E24, use this simple formula:

Syntax: =MIN(C17:E24)

Result: READ:  How to use the Excel CODE function #### Excel

View all posts by Excel →