Excel like a finance pro.
← The libraryPractice · 2 questions →
Statistical function
MINA
Returns the smallest value in a list, counting text as 0 and TRUE as 1.
Rarely usedDifficulty 1100 · ProficientUsage rank #249 of 520
When to use it
MIN that counts TRUE as 1, FALSE as 0, and text as 0.
The shape of it
- Syntax
=MINA(value1, [value2], ...)
Worked examples
Logical
=MINA(0.5,TRUE) → 0.5
TRUE is 1, so 0.5 wins.
Text as zero
=MINA(3,"text") → 0
Text counts as 0.
Range with a logical
=MINA(A2:A4) → 0
A2:A4 holds 5, 8, and FALSE.
Worth knowing
- Use when a placeholder should count as zero.
- MIN ignores text and logicals instead.
- Blanks are still skipped.
Where it goes wrong
- Text silently becomes 0 and often becomes the minimum.
- Numbers stored as text count as 0.
Related
Learn the moves here — or let Wauvel run them on your numbers.
Meet your AI CFO →One CFO-grade Excel tip a week
A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.