MINA Function

Summary

The Excel MINA function returns the smallest value in a set while also taking logical values into account. That makes it the counterpart to MAXA. In MINA, FALSE is treated as 0 and TRUE is treated as 1, so logical test results can change the minimum.

MINA is helpful when the worksheet mixes numeric values with logical states and you want both types to remain part of the comparison. It is especially relevant in control sheets, progress tracking, and decision models where a FALSE result should count as a real low point rather than being ignored.

MINA is useful when the workbook should treat logical values and mixed content as part of the minimum instead of ignoring them. That gives it a different role from MIN in models where TRUE, FALSE, or text placeholders carry meaningful structure.

Syntax

=MINA(value1, [value2], ...)

You can supply individual arguments, arrays, or range references. For example, =MINA(A1:A10) checks the range and returns the smallest value that MINA recognizes.

Arguments

• value1 - The first value, range, or array to evaluate.
• value2, ... - Additional values, ranges, or arrays to include.

As with MAXA, the key detail is input handling. Logical values are included. Text typed directly as an argument is treated as 0, but text inside a referenced range is ignored rather than converted to a numeric zero.

MINA vs Other Functions

MINA is the right tool only when the logical layer of the data should affect the result.

If the range contains positive decimals and also includes FALSE, MINA often returns 0 because FALSE evaluates to 0. That is usually the clearest sign that MINA, not MIN, is controlling the result.

Using the MINA Function

MINA is useful when a model combines numeric progress with pass/fail or yes/no states. A range such as 0.45, 0.80, and FALSE contains both magnitudes and a logical failure. MINA treats that FALSE as 0, which means the formula surfaces the failed state as the minimum.

This behavior can be valuable in review sheets where a failed condition should dominate the analysis. If a range contains healthy percentages but one critical test is FALSE, returning 0 may be exactly what you want because it shows that the range includes a failing element.

But the same behavior can also be undesirable if the goal is strictly numeric analysis. In that case, MIN is usually better because it ignores logical values in references. The decision is not about which function is better overall; it is about whether logical states belong in the comparison.

• Use MINA when FALSE should count as a meaningful low value.
• Use MIN instead when only numeric measurements should determine the minimum.
• Review mixed ranges carefully so logical results do not change the answer unexpectedly.

Example 1 - FALSE Becomes the Minimum

This range contains 0.85, FALSE, and 0.45. MINA treats FALSE as 0, so the result is 0. That is the core behavior of the function and the main reason it can differ from MIN.

=MINA(B1:B3)

Example 2 - Text Notes Do Not Become Zero in a Referenced Range

This example contains a text note, 1, and 5. Because the text cell is part of a referenced range, MINA ignores it and compares the numeric values that remain. The result is therefore 1, not 0.

=MINA(B1:B3)

Example 3 - Compare Partial Scores with Logical Status

The values are 0.95, TRUE, and FALSE. MINA converts those logical results to 1 and 0, so the formula returns 0. In a status review, that makes the failed condition visible as the minimum of the range.

=MINA(B1:B3)

Example 4 - Review a Mixed Status Range

This pattern appears in many operational sheets: one result is a ratio, another is a logical check, and a third is an alternate score. MINA applies one set of rules to all of them and returns the smallest recognized value.

=MINA(B1:B3)

Conclusion Recap

MINA works like MIN, but it keeps logical values in the calculation. This lesson showed why that changes the answer: FALSE becomes 0, so a failed logical check can become the minimum even when all the visible numbers are above zero.

That makes MINA useful in sheets where a logical failure should show up as the lowest result. But if the goal is only numeric analysis, MIN is usually better because it ignores those logical values instead of letting them drive the minimum.

• Main job: MINA returns the minimum while including logical values.
• Logical rule: FALSE evaluates to 0 and TRUE evaluates to 1.
• Important nuance: Text typed directly as an argument is treated as 0, but text inside a referenced range is ignored.
• Best use: Mixed ranges where logical test results should influence the minimum.