By Laura

- Excel – LARGE function, returning largest value number k
- Excel – Examples and guidance for VALUE function- a function for converting string to number
- Excel - How to using the SUM function
- Excel - PRODUCT function for multiplying

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

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

Related software

Excel to Image Converter is a program that provides users powerful tools for converting Excel files to JPG/TIFF/BMP/EPS/PS/PNG/PCX effectively with good quality.

- Excel Power Expander - Expand formulas and utilities for Excel
- Excel Calendar Template - Designing calendar templates with MS Excel
- Total Excel Converter - Convert Excel to PDF

Excel – Examples and guidance for VALUE function- a function for converting string to number

To convert a string to a number, Excel supports you a function - VALUE function. Normally, you do not need to use Value function since Excel will

Excel – AVEDEV function, calculating absolute deviation average

In the analysis and data processing, you have to calculate the absolute deviation average of given variables. AVEDEV function will help you solve

AVERAGEIFS function, calculating average with multiple conditions

You have to calculate average score of subjects or numbers with given conditions. The consideration of conditions will be time-consuming without

Excel – AVERAGEIF function, calculating average with conditions

AVERAGEIF is used for calculating average of cells with given conditions. The function for calculating average with conditions is more sufficient and

Excel - PRODUCT function for multiplying

To multiply numbers, Excel supports you with a very convenient function-PRODUCT. This function helps you multiply numbers quickly and