How to use the Excel MAXA function

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:

maxa - How to use the Excel MAXA function

Based on the Excel spreadsheet above, the following MAXA examples would return:

1.1 Syntax: =MAXA(E2:E9)

Result:

maxa excel function - How to use the Excel MAXA function

1.2 Syntax: =MAXA(C2:C9,55)

Result:

maxa excel function 2 - How to use the Excel MAXA function

1.3 Syntax: =MAXA(C2:C9,120)

Result:

maxa excel function 1 - How to use the Excel MAXA function

READ:  How to use sumifs in excel

Add a Comment

Your email address will not be published. Required fields are marked *