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 uses only numbers. Empty cells and text representations of numbers are ignored.
Logical values are evaluated as follows:
TRUE = 1
FALSE = 0 (including arguments containing text)
If the arguments contain no values, MAXA() and MINA() return 0
.
Example. To show how MAXA() evaluates logical values (TRUE or FALSE) to 0 or 1, we used numbers between 0 and 1 in the example table (see Figure 12-95).
MAXA() returns 1
because the largest value is the logical value TRUE.
Sample Files
Use the MAXA&MINA worksheet in the Count.xls or Count.xlsx sample file. The sample files are found in the Chapter12 folder. For more information about the sample files, see the section titled Using the Sample Files.
3.145.9.148