Excel MAX vs. Excel MAXA Formula
May 26, 2021
MAX Function
The MAX function returns the largest numeric value in a range ignoring empty cells, text values, and logical values TRUE & FALSE.
1. The syntax of the function is: MAX( number1, [number2], … )
2. Can use up to 255 number arguments.
a. Examples
MAXA Function
The MAXA function returns the largest value from set of numeric values, while counting text and the logical value FALSE as 0 and TRUE as the value 1.
1. The syntax of the function is: MAXA( number1, [number2], … )
2. Can use up to 255 number arguments.
a. Examples
