# MS Excel: MAXA Function (WS)

This Excel tutorial explains how to use the Excel MAXA function with syntax and examples.

## Description

The Microsoft Excel MAXA function returns the largest value from the values provided. The MAXA function compares numbers, text, and logical values (TRUE or FALSE).

## Syntax

The syntax for the Microsoft Excel MAXA function is:

`MAXA( value1, [value2, ... value_n] )`

### Parameters or Arguments

value1
It can be a number, text representation of numbers, or logical values.
value2, ... value_n
Optional. These can be numbers, text representations of numbers, or logical values. There can be up to 30 values entered.

## Applies To

The MAXA function can be used in the following versions of Microsoft Excel:

• Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000

## Type of Excel Function

The MAXA function can be used in Microsoft Excel as the following type of function:

• Worksheet function (WS)

## Example (as Worksheet Function)

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:

```=MAXA(A2, A3)
Result: 0.5

=MAXA(A2:A4)
Result: 0.891

=MAXA(A2:A6)
Result: 1   (as TRUE evaluates to 1 and FALSE evaluates to 0)

=MAXA(A2, A3, 1.6)
Result: 1.6```
Share: