In this article
MINA is MIN that also counts text as 0 and TRUE as 1, FALSE as 0.
Advertisement
Syntax
=MINA(value1, [value2], ...)| Argument | What it means |
|---|---|
value1… |
Values |
Examples
Example 1
=MINA(A2:C2)Result: 0. See the worked example table below for more cases.
MINA in practice
Where you will use it
- Mixed data where text means zero
- Logical checks
- Data quality checks
Worked example
| Value 1 | Value 2 | Value 3 | Formula | Result |
|---|---|---|---|---|
| 80 | Absent | 70 | =MINA(A2:C2) | 0 |
| 80 | TRUE | 70 | =MINA(A3:C3) | 1 |
| 80 | 70 | 90 | =MINA(A4:C4) | 70 |
Results calculated in Excel. Text counts as 0 and TRUE as 1, so MINA returns 0 and 1 where MIN would return 70.
Mistakes people make
| Mistake | What to do instead |
|---|---|
| Text treated as 0 | MINA of a list with 'Absent' is 0 |
| Normal use | MIN ignores text |
Related functions
📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.
Advertisement
✨ Ask AI about this article
Stuck on a step? Ask a question and the AI answers using this article.
Free · AI can be wrong