Excel – MAXA function, returning largest value

By Laura

MAXA function returns the largest value, including logic value and numerical value in document. You can use this function to find out the largest value, highest score in class, etc.

MAXA function helps you find out the largest value in a given array of cells and elements. Let’s follow this article to understand the syntax and usage of MAXA function in Excel.

GUIDE TO USE MAXA FUNCTION IN EXCEL - ILLUSTRATION

Syntax: MAXA(Value1, [value2], [value3],…)

In which:

Value1 is compulsory argument.

Value2, Value3,… are options.

Arguments Value1, Value2,… can be text, name, array of cell (C1:C5), reference value (=C5), logic value: TRUE (equal to 1) or FALSE (equal to 0), or text number (one, two, three…), this function will take the value of the cell as 1.

Example: Given a transcript of some students, let’s find the highest value in Scores column.

Use the formula in cell C9: MAXA(C2:C8) or MAXA(C2;C3;C4;C5;C6;C7;C8).

Result:

In the scope of above article, we have instructed you to use MAXA function – returning the largest value in Excel. By using this function, you can find the largest value in a given data array, including logic values, etc.

 

Related Articles:
Excel – AVERAGEIF function, calculating average with conditions
Excel – FREQUENCY function, counting frequently-appeared values
Excel - LEFT function, for cutting left string
AVERAGEIFS function, calculating average with multiple conditions
Excel – HLOOKUP function - a search function in Excel
Excel - How to use the ConcateNate function to connect character strings in Excel

Comments

Comments

Tags:

maxa function in excel

,

function returning the largest value

,

maxa function in excel 2003

, maxa function in excel 2007 maxa function in excel 2010 maxa function in excel 2013


Related software

Latest update

Copyright BETDOWNLOAD.COM © 2014 - All rights reserved