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:

min excel 1 - How to use min function in excel

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

Syntax: =MIN(C17:C24)

Result:

excel min function - How to use min function in excel

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:

min function excel - How to use min function in excel

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

Syntax: =MIN(C17:E24)

Result:

min function excel 1 - How to use min function in excel

Add a Comment

Your email address will not be published. Required fields are marked *