MAXA Function in LibreOffice Calc — Tested Examples
An explanation of LibreOffice Calc MAXA, including tested formulas, examples, expected results and common mistakes.
Tested: Examples checked in LibreOffice Calc 25.2.3.2. What this means
Returns the maximum value in a list of arguments. Text is evaluated as Zero. TRUE is treated as 1 and FALSE as 0. In the second example, the maximum of FALSE (0) and −2 is 0.
Syntax and arguments
=MAXA(Value_)
LibreOffice Calc formulas generally separate arguments with semicolons (;).
| Argument | Explanation |
|---|---|
Value |
Value 1, value 2, are arguments whose largest value is to be determined. |
Worked examples
Example 1: Compare numeric and logical values
=MAXA(TRUE();2)
Expected result: 2. This value was returned in the LibreOffice Calc 25.2 test.
Example 2: Include FALSE as zero
=MAXA(FALSE();-2)
Expected result: 0. This value was returned in the LibreOffice Calc 25.2 test.
How to interpret the result
TRUE is treated as 1 and FALSE as 0. In the second example, the maximum of FALSE (0) and −2 is 0.
Mistakes and troubleshooting
- Check inputs and assumptions: MAX and MAXA do not treat all logical and text inputs identically. Check whether those entries are intentional.
- Check argument order and format: Strings go in quotes, cell references do not. Functions that return arrays may require special entry.
- Verify your own data: Reproduce the example first. If your formula returns an error, inspect the referenced cells and individual argument values.
Related functions
Tested version and primary reference
2 example(s) on this page passed real calculations in LibreOffice Calc 25.2.3.2. This is not a claim about every possible input or other spreadsheet applications.