MAXA Function (OpenOffice Calc)

• Introduced: First release not established; documented by OpenOffice.org 3.3.
• Supported in: Apache OpenOffice 4.1.16; this identifies a verified release, not a final supported version.
• Scope: Desktop Calc, English function names and semicolon-separated formulas.
• Checked: October 14, 2026. Eight reference formulas and the listed diagnostics were recalculated from generated native ODF in 4.1.16 on Linux x86-64, Build 9816. Source and independent reference calculations were also checked.

MAXA returns the largest included value under A-function coercion. Text contributes zero, rather than disappearing, and logical values contribute 1 or 0. In an all-negative numeric group, adding a text cell can therefore raise the result to zero. Release entry.

=MAXA(Value1 [; Value2; ...])

Supply numeric values, logical values, text, cell references or ranges. TRUE contributes 1 and FALSE contributes 0. Text contributes 0, including the directly supplied numeric-looking string “7”; it is not converted to seven. A genuinely empty referenced cell is ignored. A cell holding text and a cell with no content are therefore different inputs.

Enter these values at the exact addresses before using the range examples. F7 and F8 must be text; enter an apostrophe before 7 to force F8 to text. Enter TRUE() and FALSE() as logical formulas or use logical cell values. Leave the specified cells genuinely empty.

F2:F8 therefore contributes the seven numbers 1, 3, 5, 1, 0, 0, 0. G2:G5 contributes only 2, 4, 6; its final blank is not an extra observation.

The native column records the saved 4.1.16 results. The independent values use high-precision mathematics; displayed decimals are rounded to twelve places. The data setup above is required for range formulas.

For a nonempty column of genuine logical alert flags, MAXA is 1 when any flag is TRUE and 0 when they are all FALSE. The native H2:H5 example contains TRUE, FALSE, TRUE and a blank, producing 1. This can be a useful numeric flag for a dashboard if the column really contains logical values.

For ordinary measurements, do not assume the A suffix means safer cleaning. A group containing −5, −2 and the text “missing” has MAXA 0, even though no measurement reached zero. Retain a separate data-quality flag or clean the measurement column before choosing a numeric aggregate.

The F2:F8 example returns 5 because neither a logical 1 nor any text-as-zero exceeds the numeric maximum. That apparent agreement with a numeric-only maximum does not prove the coercion was irrelevant in other datasets. Test a negative-only subset when auditing an imported column.

For valid nonempty groups, the maximum of the combined group equals the larger of their separate MAXA values. If an empty group is allowed, the source fallback of zero can make a naïve regrouping comparison misleading for negative data. Keep the group-population check separate from the maximum.

=MAXA("7";2) returns 2, not 7: the string contributes zero. =MAXA(H5) returns zero for an actually blank reference, but =MAXA() returns Err:511. A text cell containing TRUE does not have the same type as a logical TRUE. This guide does not establish all array, error-cell or extreme-number combinations.

These additional formulas were recalculated from the same generated ODF input. H5 is a deliberately empty cell where referenced. Error displays are retained as errors, even when an ODS numeric attribute stores zero.

max, min, AVERAGEA.

• Function-specific release entry
• A-function text-as-zero dispatch

The generated ODF input produced the informational load warning “Not all attributes could be read.” After it was acknowledged, the sheet was hard-recalculated and saved separately. Every formula identity, typed input, input label and tested result was reconciled. True empty cells were distinguished from text and logical values. This does not certify every style attribute. The separately prepared XLSX input was not executed. A deliberately stale SUM cache changed from 999999 to 3, and an uncached SUM returned 7 after hard recalculation. Native evidence covers the eight reference formulas and listed diagnostics only. Other explanatory compositions are independent mathematical checks; other releases, locales and extreme-value behavior were not established by this run.