Functions
MIN
Minimum value
Try it
When to use it
When should I use MIN instead of SMALL?
Use MIN for the single lowest value; use SMALL when you need the second-lowest, third-lowest, and so on.
Does MIN ignore text and blanks?
Yes. MIN considers only numeric values and skips text and empty cells.
Use cases
Get the smallest value from a list
Identify the lowest quoted price
Used in
Syntax
MIN(value1,...)Examples
=MIN({4,26,2,14,5}) // => 2
=MIN({1,2,3,4,5},26,4) // => 1
=MIN({-3,0,5,10}) // => -3