MAXA
Returns the maximum value in a list of arguments, including numbers, text, and logical values.
StatisticalStatistics & Analysis
What it does
Calculates max value, treating TRUE=1, text/FALSE=0.
Syntax
MAXA(value1, [value2], ...)
Arguments
value1(value) — Value or range.
Examples
Max with Logicals
Max of -5 and TRUE.
FORMULA
=MAXA(-5, TRUE)
RESULT
1
SAMPLE DATA
| A | B | |
|---|---|---|
| 1 | Val1 | Val2 |
| 2 | -5 |