MINA Function (Calligra Sheets)

• Introduced: First release not established; the name is present in Calligra 2.4.0 source.
• Supported in: Calligra Sheets 26.08.2, with no retirement established.
• Scope: Desktop Sheets with the Math module. Examples use English semicolon-separated formulas.
• Checked: October 14, 2026. Selected formulas ran through the official 25.04.2 engine library. Source and independent mathematics were checked. This is engine evidence, with no GUI-cell or import verification; 26.08.2 was source-checked only.

MINA finds the smallest value after its full-value conversion. Numeric strings participate as numbers, TRUE/FALSE become 1/0, and nonnumeric strings become zero. This differs from MIN’s numeric-only collection. The error conversion described above is a separate implementation limitation, not a mathematical definition of minimum. Function-specific official reference.

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

Supply at least one value or array. Additional arguments are optional. An empty string is a supplied string, not a genuinely empty cell; the examples preserve that distinction. Brackets indicate optional arguments and are not entered in the formula. Registration and implementation.

The engine and mathematical columns are separate. Results are rounded to twelve decimal places, or thirteen significant digits in scientific notation for very small or large values. This is a display choice, not an accuracy guarantee. Inline arrays in braces are formula values, not a workbook-import test. Their semicolons separate columns and vertical bars separate rows. Strings remain explicitly quoted, and booleans use TRUE()/FALSE().

For numeric measurements 2,4,8, the minimum is 2. When an imported value is the string “9”, MINA(1;2;“9”) still returns 1 because the string converts to 9. A nonnumeric marker changes the result: MINA(1;2;“abc”) returns 0. That zero is not an observed measurement.

If a dataset combines numbers with TRUE/FALSE flags, a FALSE contributes zero. Keep flags in a separate column when they do not belong in the minimum. Converting text is useful only when the conversion reflects the intended data meaning.

For clean numbers, translation and positive scaling preserve order: min(x+c)=min(x)+c and min(kx)=k×min(x) for k>0. These identities do not justify treating missing, invalid or error values as measurements.

The check below compares MINA with MIN on 3,5 and the numeric string “1”. MINA includes the converted 1; MIN ignores that string and returns 3. The difference is −2. The explicit inputs make this a coercion comparison rather than an unexplained change in a dataset.

The executed advanced check was:

=MINA(3;5;"1")-MIN(3;5;"1")

Its engine result was -2.

The tested error cases demonstrate why a plausible answer can still be unsafe: MINA({1;2;1/0}) returns 0, while MINA({1;-2;1/0}) returns −2. The error is converted to zero and then participates in ordering; it is not always visible in the final answer. A no-argument call gives #VALUE!.

The table covers direct scalars and inline arrays. No blank worksheet range, import or GUI-cell result is established here. Do not infer that MINA and MAXA propagate errors identically: the tested MAXA error path does propagate #DIV/0!.

• Function-specific implementation
• Versioned function help
• Min Max Walk helper
• Numeric Conversion helper
• Comparison helper
• Min Max helper
• Defaults helper
• Array Parser helper

The math module and value-calculation helpers are byte-identical between the inspected 25.04.2 and 26.08.2 sources. That comparison supports the source discussion but does not establish later-version execution, GUI-cell behavior or other locales.

MIN, MAX, COUNT.