ReferenceFunctionsMath Functions
MIN
MIN: Returns the smallest numeric value from one or more arguments.
Summary
MIN scans scalar values and ranges, considering only values that can be treated as numbers.
Remarks
- Errors in any scalar argument or range cell propagate immediately.
- In ranges, non-numeric cells are ignored.
- Scalar text is included only when it can be coerced to a number.
- If no numeric value is found,
MINreturns0.
Examples
Minimum in a numeric range
Grid
| Cell | Value | |
|---|---|---|
Formula
=
Result
Not evaluated yet.
Expected
-2
Coercible scalar text participates
Grid
| Cell | Value | |
|---|---|---|
| No inputs on Sheet1. | ||
Formula
=
Result
Not evaluated yet.
Expected
3
No numeric values returns zero
Grid
| Cell | Value | |
|---|---|---|
| No inputs on Sheet1. | ||
Formula
=
Result
Not evaluated yet.
Expected
0
Related functions
FAQ
Why can MIN return 0 even when no numbers are present?
If nothing numeric is found after coercion/scan, MIN falls back to 0.
Do errors in referenced ranges get ignored?
No. Any encountered range or scalar error is propagated.
Runtime metadata
Category
Math
Signature
MIN(arg1…: Number (Range))This function accepts a repeating argument pattern (min args: 1).
Arity
min 1, max variadic
Arguments
arg1Number · Range · coercion NumberLenientText
Caps
PUREREDUCTIONNUMERIC_ONLY
Source