Statistical
MAXA Function in Excel
Returns the largest value in a list of arguments, including text and logical values. Text and FALSE = 0, TRUE = 1.
Syntax
- =MAXA(value1, [value2], ...)
Arguments
- value1 (required): First value or range
- value2 (optional): Additional values or ranges
Examples
- =MAXA(1, 2, TRUE) - Max with TRUE (=1) - Result: 2
- =MAXA(-5, FALSE, "text") - Max with text and FALSE (both=0) - Result: 0
MAXA for data analysis
- Confirm whether you need entire columns, filtered subsets, or distinct values.
- Use [COUNTIFS](/functions/countifs/) and [SUMIFS](/functions/sumifs/) for multi-criteria metrics.
- Pivot tables complement single-cell statistical formulas for exploration.
Common errors
- Text evaluates to 0, not ignored like in MAX
Use cases
- Finding maximum including logical values
- Mixed data analysis
Frequently asked questions
- What is the MAXA function in Excel? MAXA returns the largest value in a list of arguments, including text and logical values. Text and FALSE = 0, TRUE = 1. The syntax is =MAXA(value1, [value2], ...). Typical use cases include finding maximum including logical values, mixed data analysis.
- How do I use the MAXA function? To use MAXA, type =MAXA( in a cell and provide the required arguments. Excel will show you the syntax and parameter hints as you type. Make sure to close the parentheses and press Enter to execute the function.
- What type of data does MAXA work with? MAXA works with numerical data and can handle ranges, arrays, and individual values. It ignores text values and empty cells in its calculations, focusing only on numeric data for accurate statistical analysis.
- Why is MAXA not working in my Excel? Common issues with MAXA include Text evaluates to 0, not ignored like in MAX. Start by checking the syntax =MAXA(value1, [value2], ...), then verify each referenced cell or range.
Editorial review
- Reviewed by Excel.Directory Editorial Team. Updated May 2026.