MINA
Returns the smallest value in a set, treating text as 0 and TRUE as 1, FALSE as 0. Unlike MIN which ignores text and logical values.
MINA(value1, [value2], ...)Arguments
value1First value, reference, or range.value2Optional. Up to 254 additional values, references, or ranges.(optional)
=MINA(2, 5, "text")Text counts as 0, which is less than 2 and 5
=MINA(0.5, TRUE)TRUE counts as 1, so 0.5 is the minimum
- •Use MIN if you want to ignore text and logical values
- •Empty cells are ignored
- •Useful when blank-vs-text distinction matters in score sheets
- •Forgetting that MINA treats text as 0, which can produce a surprisingly low result if a range of otherwise positive numbers contains stray text - the text's value of 0 becomes the minimum
- •Confusing MINA with MIN - MIN ignores text and logical values completely, while MINA includes them using the 0/1 conversion rules, and choosing the wrong one changes the result whenever non-numeric entries are present
- •Expecting MINA to return an error or blank when the range has no genuine numbers - it returns 0 in that case, treating any text found as the minimum value of 0
MINIgnores text and logical values entirely rather than converting them to 0 or 1 like MINA, giving a different result whenever non-numeric entries are present.MAXAApplies the same text-as-0, TRUE-as-1 conversion rules as MINA, but to find the largest value instead of the smallest.SMALLFinds the nth smallest value in a purely numeric range, a different tool than MINA when text/logical inclusion isn't relevant.Why did MINA return 0 when all my numbers are positive?
The range likely contains a text entry, which MINA treats as 0 - since 0 is less than any positive number, it becomes the minimum.
What's the difference between MINA and MIN?
MIN ignores text and logical values completely, finding the smallest value only among genuine numbers. MINA instead converts TRUE to 1, FALSE to 0, and any text to 0, including them in the comparison.
When is MINA useful in a real scenario?
It's helpful in score sheets or data validation where distinguishing a genuine 0 score from a blank or text placeholder matters, since MINA treats text entries as an explicit 0 rather than ignoring them like MIN does.
Need to translate a formula using MINA?
Use our translator to convert your complete formula