Functions
MAXA
Maximum including booleans and text
Try it
When to use it
When should I use MAXA instead of MAX?
Use MAXA when your range may contain logical values (TRUE/FALSE) or text strings that you want included in the comparison — MAXA treats TRUE as 1, FALSE and text as 0. MAX silently ignores non-numeric cells.
Used in
Syntax
MAXA(value1,...)Examples
=MAXA(1,2,3,4,5) // => 5
=MAXA({1,2,3},{4,5,6},4,26) // => 26