MINA Function
Returns the smallest value, counting text as 0 and TRUE as 1.
Category
Statistical
Available in
All versions, Microsoft 365
Returns
A number
Want to practice MINA in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox
Overview
MINA works like MIN, but in a range it also counts text (as 0), TRUE (as 1) and FALSE (as 0). Empty cells are still skipped.
Useful when a text entry such as "offline" should count as zero.
Syntax
=MINA(value1, [value2], …)
Arguments
| Argument | Required? | What it does |
|---|---|---|
| value1 | Yes | A value, cell or range. |
| value2, … | No | Up to 255 more values, cells or ranges. |
Examples
Example 1 — Lowest reading, counting outages
A warehouse sensor logs "offline" when it stops reporting.
D2fx=MINA(B2:B5)
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Hour | Reading | MINA | |
| 2 | 09:00 | 4.5 | 0 | |
| 3 | 10:00 | 3.8 | MIN | |
| 4 | 11:00 | offline | 3.8 | |
| 5 | 12:00 | 5.2 |
=MINA(B2:B5) Explain
Common mistakes
- Text becomes the minimum. With positive numbers, any text in the range makes MINA return 0. Use MIN to ignore text.
Notes

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.