MAX vs MAXA Function in Excel with example

MAX vs MAXA Function in Excel with example

MAX

The Excel MAX function returns the largest numeric value in a range of values. The MAX function ignores empty cells, the logical values TRUE and FALSE, and text values. The largest value in the array. number1, number2 number255, reference to numeric value, or range that contains numeric values.

Syntax

=MAX(number1,number2,number3,…….number255)

Formula Example

Output

MAXA

The Excel MAXA function returns the largest numeric value in a range of values. The MAXA function ignores empty cells, but evaluates the logical values TRUE and FALSE as 1 and 0, respectively. Return largest value1,value2,value3…. value255, reference to numeric value, or range that contains numeric values.

Syntax

=MAXA(value1,value2,value3…..value255)

Formula Example

Output

Leave a Reply

Your email address will not be published.