logo-mini
  1. Excel Guru
  2. MIN Function

MIN Function

The Excel MIN function is a useful tool for finding the smallest value in a range of cells. It can be used in a variety of different scenarios, such as finding the lowest score on a test or the smallest number in a list of expenses. Here are some steps for using the MIN function in Excel:

  1. Begin by selecting the cell where you want to display the minimum value. This is typically done by clicking on the cell with your mouse.
  2. Type “=MIN(” into the cell, followed by the range of cells that you want to find the minimum value for. For example, if you want to find the minimum value for cells A1 through A5, you would type “=MIN(A1:A5)”.
  3. Press the Enter key to complete the function. The minimum value in the specified range will be displayed in the cell you selected.
  4. You can also use the MIN function with multiple ranges. To do this, simply add a comma between each range and enclose each range in parentheses. For example, to find the minimum value for cells A1 through A5 and B1 through B5, you would type “=MIN(A1:A5, B1:B5)”.
  5. You can also use the MIN function with other functions, such as the IF function. For example, you could use the MIN function to find the lowest score on a test that is above a certain threshold. To do this, you would use the IF function to only include scores that are above the threshold, and then use the MIN function to find the minimum value of those scores.
  6. You can also use the MIN function with cell references. To do this, simply replace the range of cells with a cell reference. For example, if you want to find the minimum value in a range of cells that is specified in cell C1, you would type “=MIN(C1)”.
  7. The MIN function also has several optional arguments that you can use to customize its behavior. For example, you can use the “ignore_empty” argument to ignore empty cells when finding the minimum value.

In summary, the Excel MIN function is a useful tool for finding the smallest value in a range of cells. It is easy to use and can be customized with optional arguments to fit your specific needs.

Download the sample files: MIN FUNCTION – Click here