What is the MIN Function
The MIN function returns the smallest number in a range or list. It ignores text, blanks, and logical values. MIN is useful for finding lowest values, minimum scores, and bottom performance.
Formula: =MIN(number1, [number2], ...)
Practical Example 1
Sales are in B2:B10.
Type: =MIN(B2:B10)
Result: the lowest sale value
Practical Example 2
Get the lowest mark in a class.
Type: =MIN(C2:C20)
Result: the bottom score
Practical Example 3
MIN with a condition using MINIFS.
Type: =MINIFS(C:C, A:A, Dhaka)
Result: the lowest sales in Dhaka
When to Use It
MIN is used for finding lowest sales, minimum scores, lowest temperatures, bottom performers, and any analysis that needs the smallest value in a dataset.