MIN
Return the smallest numeric value, ignoring text and blanks.
Syntax
MIN(number1, [number2], ...)| Argument | Required | Description |
|---|---|---|
number1 | Required | A range or value. |
number2 | Optional | Further ranges or values. |
Examples
Every example below was executed against VisiGrid engine 0.35.0 — not
transcribed from another vendor's documentation. Reproduce any of them with vgrid calc.
| Formula | Result | Notes |
|---|---|---|
=MIN(A1:A5) | 10 | |
=MIN(A1:A5,5) | 5 | Ranges and single values can be mixed. |
Capping a value
MIN(A1, 100) is the standard ceiling — the value, or 100, whichever is
smaller. Paired with MAX it clamps:
=MIN(MAX(A1, 0), 100)Never below zero, never above a hundred, in one expression and with no IF.
Like MAX, an empty range returns 0 rather than an error, which is worth a
guard when your data can legitimately be all-positive and the range can
legitimately be empty.
Excel compatibility
Matches Excel.