How to Use Excel MAXA Function in Office 365? – [with Examples]
Tags: excelfunctions, excelmaxafunctionino
Published: 2020-09-04 12:23:40

---
title: How to Use Excel MAXA Function in Office 365? – [with Examples]
published: true
date: 2020-09-04 06:51:45 UTC
tags: ExcelFunctions,ExcelMAXAFunctioninO
canonical_url: https://geekexcel.com/how-to-use-excel-maxa-function-in-office-365-with-examples/
---

## Excel MAXA Function:

![MAXA Function](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/MAXA-Function.png)<figcaption id="caption-attachment-13324">MAXA Function</figcaption>

This article describes the usage of **Excel MAXA Function in Office 365** with its syntax, description, and examples. Let’s step into this article!! Get an official version of **MS Excel** from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)


## **MAXA Function – Description:**

- This function **returns the largest numeric value from the given range of values**.
- It is similar to [**MAX Function**](https://geekexcel.com/how-to-use-excel-max-function-in-office-365-with-examples/) but the only difference is **MAXA Function evaluates** the logical values **TRUE** and **FALSE** as **1** and **0**.

## **Syntax:**

**=MAXA(value1, [value2],.)**

### Argument Description:

**value1 ** – The first input number, or reference, or a range.

**value2 ** – It is an optional one. It could be a number, or reference, or a range that contains numeric values.

### Note:

- This function accept up to **255 arguments only**.
- If the arguments contain **no numbers** and then it returns **0**.
- This function evaluates logical values **TRUE & FALSE** as **1** and **0**.
- It ignores the **empty cells**.

## **Examples:**

The following examples will help you to know, how it works.

### Example 1:

- Refer to the below screenshot.
- You can see the input values in **Column A, B, C, and D**. The output **MAXA values** are listed in **Column E**.
- This function evaluates logical values **TRUE & FALSE** as **0** and **1 (refer to the output values in the cell E3 and cell E4).**

![Example 1](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/1-16.png)<figcaption id="caption-attachment-13320">Example 1</figcaption>

### Example 2:

- If the arguments contain **no numbers** and then this **MAXA Function** returns **0**.

![Example 2](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/2-13.png)<figcaption id="caption-attachment-13321">Example 2</figcaption>

From the above examples, you can understand the MAXA Function easily.

## **Sum-Up:**

In the above article, you can understand the usage of **Excel MAXA Function in Office 365** with its syntax, explanation, and examples.

Drop your **feedback** in the below comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### Similar Functions:

- [**MAX Function**](https://geekexcel.com/how-to-use-excel-max-function-in-office-365-with-examples/)
- [**MIN Function**](https://geekexcel.com/how-to-use-excel-mina-function-in-office-365-with-examples/)
- [**MINA Function**](https://geekexcel.com/how-to-use-excel-mina-function-in-office-365-with-examples/)