MS Excel: MaxA Function
In Excel, the MaxA function returns the largest value from the values provided. The MaxA function compares numbers, text, and logical values (TRUE or FALSE).
The syntax for the MaxA function is:
MaxA( value1, value2, ... value_n )
value1, value2, ... value_n are numbers, text representations of numbers, or logical values.numeric values. There can be up to 30 values entered.
Applies To:
- Excel 2007, Excel 2003, Excel XP, Excel 2000
For Example:
Let's take a look at an example:
Based on the Excel spreadsheet above:
=MaxA(B2, B3) would return 0.5 =MaxA(B2:B4) would return 0.891 =MaxA(B2:B6) would return 1 (as TRUE evaluates to 1 and FALSE evaluates to 0) =MaxA(B2, B3, 1.6) would return 1.6