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
- Select the cell where you want the result to appear.
- Type
=MIN(
followed by the range or numbers to evaluate. - 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
Post a Comment