MIN Function in Excel
Beginner
Returns the smallest number in a set of values.
Syntax
=MIN(number1, [number2], ...)Example
Use Case
Find the lowest price in a list.
Common Errors to Avoid
- Ignores text and empty cells (returns 0 if all text)
- Returns 0 if range includes zero values
- Doesn't work with dates formatted as text
Pro Tips
Use MINIFS for conditional minimum values. Combine with IF for filtered minimums. To exclude zeros, use MINIFS(A:A,A:A,">0") or array formula.
Need help with this formula?
Our AI Formula Generator can write this for you instantly.
Try AI Formula Generator →