What is MIN?
Returns the smallest value in a range. Essential for finding minimum thresholds, lowest prices, and baseline values.
Syntax
=MIN(number1, [number2], ...)
Example
Formula: =MIN(D1:D5)
Result: 12
How It Works
Finds the lowest value in the range D1:D5. If the values are 25, 12, 38, 19, 45, the minimum is 12. MIN ignores text and logical values.