MAXA()
Syntax. MAXA(value1,value2,...)
Definition. This function returns the largest value in an argument list. Not only numbers but also text and logical values (TRUE and FALSE) are compared.
Arguments
value1 (required) and value2 (optional). At least one and up to 255 arguments (30 in Excel 2003 and earlier versions) for which you want to find the largest value
Background. In a table containing not only number values but also text and logical values, you can calculate the greatest and smallest value with the MAXA() or MINA() function.
The arguments for MAXA() and MINA() can be numbers, empty cells, logical values, and text representations of numbers. Incorrect values in the arguments cause errors. If an argument is an array or a reference, this range ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
