MIN Function (OpenOffice Calc)
The MIN function in OpenOffice Calc returns the smallest numeric value from a list of numbers, ranges, or mixed arguments. Learn syntax, examples, common errors, and best practices.
Compatibility
▾| Excel | ✔ |
| Gnumeric | ✔ |
| Google_sheets | ✔ |
| Libreoffice | ✔ |
| Numbers | ✖ |
| Onlyoffice | ✔ |
| Openoffice | ✔ |
| Wps | ✔ |
| Zoho | ✔ |
What the MIN Function Does â–¾
- Returns the smallest numeric value in a dataset
- Ignores text and empty cells
- Includes dates and times (because they are numeric)
- Works across sheets
- Handles large datasets efficiently
- Useful for analytics, dashboards, and reporting
MIN is ideal for identifying low performers, minimum values, and baseline measurements.
Syntax â–¾
MIN(number1; number2; ...)
Arguments:
- number1, number2, … — Individual values, cell references, or ranges
MIN ignores text, empty cells, and logical values, but includes dates and times.
Basic Examples â–¾
Find the smallest value in a range
=MIN(A1:A10)
Find the smallest value across multiple ranges
=MIN(A1:A10; C1:C10)
Find the smallest value in a list
=MIN(10; 25; 7; 99)
Result: 7
Find the earliest date
If A1:A5 contains dates:
=MIN(A1:A5)
Result: the earliest date.
Advanced Examples â–¾
Find the minimum across sheets
=MIN(Sheet1.A1:A100)
Find the minimum visible value (filtered data)
Use SUBTOTAL:
=SUBTOTAL(5; A1:A100)
Function code 5 = MIN.
Find the minimum with conditions (workaround)
OpenOffice Calc does not have MINIF, but you can use:
=MIN(IF(A1:A100="North"; B1:B100))
Confirm with Ctrl+Shift+Enter.
Find the minimum within a date range
=MIN(IF((A1:A100>=DATE(2025;1;1))*(A1:A100<=DATE(2025;12;31)); B1:B100))
Confirm with Ctrl+Shift+Enter.
Find the minimum excluding zeros
=MIN(IF(A1:A100<>0; A1:A100))
Confirm with Ctrl+Shift+Enter.
Find the minimum in a 3D range
=MIN(Sheet1:Sheet5.A1:A10)
Common Errors and Fixes â–¾
MIN returns 0 unexpectedly
Possible causes:
- All values are text
- All values are empty
- Imported numbers stored as text
- Hidden apostrophes (
'123)
Fix: Convert text to numbers:
Data → Text to Columns → OK
MIN includes values you expected it to ignore
MIN includes:
- Dates
- Times
- Numeric results of formulas
MIN excludes values you expected it to include
MIN ignores:
- Text numbers (
"123") - Empty cells
- Logical values (TRUE/FALSE)
- Errors
Err:502 — Invalid argument
Occurs when:
- A malformed range is used
- A text argument is not quoted properly
Err:508 — Missing parenthesis
Usually caused by:
- Missing
) - Using commas instead of semicolons
Best Practices â–¾
- Use MIN for numeric datasets
- Use array formulas for conditional minimums
- Convert imported text numbers to real numbers
- Avoid mixing text and numbers in the same column
- Use named ranges for cleaner formulas
- Use SUBTOTAL for filtered data
To find the bottom N values, combine MIN with the SMALL function for more flexible ranking.