MAXA in Excel: Maximum Values with Logical Flags Included

• Introduced: First introduction version is not established by the official history reviewed.
• Availability: official help lists Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel 2024, Excel 2024 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2016.
• Checked: October 14, 2026; official MAXA reference. Documentation and independently calculated examples; no native Excel execution or broader platform certification.

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

Microsoft documents a required first argument and up to 255 arguments in total. Ranges may be supplied instead of listing each cell individually. TRUE and FALSE contribute one and zero; directly supplied numeric text is separately documented as participating.

Evidence caution: the current page contains conflicting statements about text inside references, describing it as both ignored and zero-valued. The successful range examples below avoid text and use the explicit logical-value rule. The complete referenced-text and empty-string matrix remains unverified rather than silently imported from Collabora or another application.

In A2:A4 enter numeric 0.2, numeric 0.6 and the formula =TRUE():

=MAXA(A2:A4)
=MAX(A2:A4)

Expected results are 1 and 0.6. MAX ignores logical values in this referenced control, while MAXA includes the one contributed by TRUE.

Replace TRUE with FALSE. MAXA then has expected result 0.6, because the zero-valued false flag is below both numeric observations. The changed participation has not changed the maximum in that second case.

Put numeric -9, numeric -4, and FALSE in C2:C4. =MAXA(C2:C4) has expected result 0, while =MAX(C2:C4) has expected result -4.

The source contains no numeric zero, yet MAXA returns zero because it includes the logical value. Replacing FALSE with TRUE changes its expected result to 1. This does not establish that a positive measured adjustment exists.

Greatest signed value and greatest magnitude are also different questions. Among -9 and -4, the greatest numeric value is -4, while the largest magnitude is nine. MAXA does not automatically apply ABS before comparing values.

=MAXA(4,8,"12")

Expected result: 12 under Microsoft’s documented direct-argument rule. The text appears directly in the formula. This does not settle the contradictory descriptions of text read through a cell reference.

If an imported column contains identifiers such as 0012, converting them into numeric measurements can erase meaningful leading zeros. Decide whether the field is a quantity before using any numeric maximum as a summary.

Create E2:E3 containing numeric 0 and numeric -5, and G2:G3 containing FALSE and numeric -5. Both ranges have expected MAXA result 0.

Only the first range includes a measured numeric zero. ISNUMBER applied to E2 and G2 returns expected TRUE and FALSE respectively. The same aggregate can arise from different source types, so attaching a measurement label to the maximum requires more than looking at its numeric value.

Microsoft also documents zero when no values are supplied through the arguments, but this guide does not certify every empty-reference route to that condition. Do not use a zero maximum as a general completion test.

A first group contains -9 and -4; a second contains -7 and -2. The combined numeric maximum is -2. If FALSE participates in either range, MAXA’s expected combined maximum becomes 0.

Taking the maximum of group maxima reproduces the combined result when the groups use a consistent participant policy. Mixing MAX and MAXA can hide a logical contribution in one group while retaining it in another. Keep the policy visible alongside the group summaries.

If a maximum unexpectedly becomes one, inspect whether TRUE entered the source. If a negative-only register suddenly returns zero, check for FALSE before concluding that a numeric zero observation was added.

Microsoft warns that error values and unconvertible text can cause errors; MAXA is not a universal error suppressor. Complete coercion, extreme magnitudes and ambiguous text or empty-string inputs need separate native verification. A maximum value also does not resolve tied records or identify a unique winning row.

• Microsoft MAXA reference.
• Editorial testing standards.

Worked inputs are fictional. Decimal answers are independently calculated mathematical expectations rounded to nine places, not captured native results. Extreme magnitudes, complete coercion matrices and cross-version numerical accuracy remain untested.