Excel functions / Statistics
MINA function
The smallest value, counting text in a range as 0 and TRUE as 1.
Syntax
=MINA(value1, [value2], …)
Arguments
value: Values, cells or ranges.
When to use it
MINA gives the smallest value like MIN, but in a range it counts text and FALSE as 0 and TRUE as 1. A column with a note in it can therefore have a minimum of 0.
Examples
A note counts as 0
A B C 1 Value 2 12 0 3 pending 4 8 In C2:
=MINA(A2:A4)→ 0MIN would give 8.
Common mistakes
- Use MIN. MINA is for when text really should count as zero. Otherwise MIN is the one.
MINA in other languages
Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.
- Czech: MINA
- Danish: MINV
- Dutch: MINA
- Finnish: MINA
- French: MINA
- German: MINA
- Hungarian: MIN2
- Italian: MIN.VALORI
- Norwegian: MINA
- Polish: MIN.A
- Portuguese (Brazil): MÍNIMOA
- Portuguese (Portugal): MÍNIMOA
- Russian: МИНА
- Spanish: MINA
- Swedish: MINA
- Turkish: MİNA