MIN

Beginner

Statistical

Returns the smallest value in a set of numbers. Ignores text and logical values.

Syntax
=MIN(number1, [number2], ...)
Parameters
number1
Required
(number | range)

First number or range

number2(number | range)

Additional numbers or ranges (optional)

Examples
Real-world examples to help you understand how to use MIN

Find minimum value

=MIN(A1:A10)

Returns the smallest number in the range

Result: Minimum value

Min across ranges

=MIN(A1:A10, C1:C10)

Finds the smallest value across both ranges

Result: Overall minimum

Min excluding zeros

=MIN(IF(A1:A10>0, A1:A10))

Array formula to find min excluding zeros

Result: Min positive value

Common Use Cases
  • ✓Find lowest price
  • ✓Identify minimum temperature
  • ✓Track lowest score
  • ✓Find floor values
  • ✓Quality control thresholds
Pro Tips
  • 💡MIN ignores empty cells and text
  • 💡Use MINA to include logical values
  • 💡Combine with IF to exclude certain values
  • 💡MINIFS for min with multiple criteria
Common Errors
  • ⚠️Not excluding zero values when needed
  • ⚠️Including text (they're ignored)
  • ⚠️Not handling empty ranges
Related Formulas
MAXSMALLMINAMINIFS

Need a Custom MIN Formula?

Our AI can generate tailored formulas based on your specific needs

Generate Custom Formula