The MAXA function helps you find the maximum value in a given range of cells and elements. Follow the article below to understand the syntax and usage of the MAXA function in Excel.
Syntax: =MAXA(value1,[value2],…)
The MAXA function syntax has the following arguments:
- value1 – Number, reference to numeric value, or range that contains numeric values.
- value2 – [optional] Number, reference to numeric value, or range that contains numeric values.
Example: Let’s look at some Excel MAXA function examples and explore how to use the MAXA function as a worksheet function in Microsoft Excel:
Based on the Excel spreadsheet above, the following MAXA examples would return:
1.1 Syntax: =MAXA(E2:E9)
Result:
1.2 Syntax: =MAXA(C2:C9,55)
Result:
1.3 Syntax: =MAXA(C2:C9,120)
Result:
