MIN
Returns the smallest value in a set of values.
=MIN(number1, [number2], ...)This static page keeps the function indexed for search, while the spreadsheet app handles interactive exploration and saved formulas.
What the function does
Overview
Returns the smallest value in a set of values.
The MIN function evaluates a set of values and returns the smallest numerical result. It supports up to 255 arguments, which can include individual numbers, cell references, ranges, or arrays. A critical technical distinction is how it handles non-numeric data: when referencing cells, MIN ignores empty cells, logical values (TRUE and FALSE), and text. However, if logical values or numbers represented as text are entered directly into the function arguments (e.g., =MIN(1, "2", TRUE)), they are evaluated. For best results, ensure your data range is formatted as numbers or dates. To find the minimum value based on specific conditions, consider using the MINIFS function or an array-based MIN(IF()) construct in older Excel versions. If the arguments contain no numbers, the function returns 0.
Quick reference
Syntax
=MIN(number1, [number2], ...)Inputs
Arguments
Example: A2:A100
Formula patterns
Examples
Finding the lowest unit price in a list
=MIN(B2:B20)Determining the earliest start date among multiple tasks
=MIN(C2, E2, G2)Capping a calculation at a maximum threshold
=MIN(A2*0.15, 500)Avoid these issues
Common Errors
0 (unexpected)
Cause: The referenced range contains only text or numbers formatted as text, which the function ignores, leading to a default return of zero if no valid numbers are found.
Fix: Use the VALUE function or the 'Text to Columns' tool to convert text-based numbers into true numeric values.
#VALUE!
Cause: An argument provided directly in the formula (not a cell reference) is a text string that cannot be interpreted as a number.
Fix: Check the arguments typed directly into the formula and ensure they are numbers or references to numeric cells.
Platform support
Compatibility
Source: Microsoft Support
Common questions
Frequently Asked Questions
Returns the smallest value in a set of values.
number1: Range to check
0 (unexpected): Use the VALUE function or the 'Text to Columns' tool to convert text-based numbers into true numeric values. #VALUE!: Check the arguments typed directly into the formula and ensure they are numbers or references to numeric cells.