105. Calculating minimum values with MIN

Calculating Minimum Values with the MIN Function

The **MIN** function in Excel is used to find the smallest number in a range of values. It is particularly useful for identifying the minimum value in datasets such as grades, sales figures, or measurements.

Syntax of the MIN Function

=MIN(number1, [number2], ...)
    
  • number1: The first number, cell reference, or range.
  • [number2]: (Optional) Additional numbers, cell references, or ranges.

Steps to Use the MIN Function

  1. Select the cell where you want the result to appear.
  2. Type =MIN( followed by the range or numbers to evaluate.
  3. Close the parentheses ) and press Enter to see the result.

Interactive Example: MIN Function

Item Value
Score 1 85
Score 2 90
Score 3 78
Minimum Value Click Calculate

Edit the values in the table above and click "Calculate Minimum" to see the MIN function in action.

This example demonstrates how the MIN function calculates the smallest value in a range of numbers in Excel.

Comments