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**: