The MAXA function returns the largest numeric value in a set containing any values.
MAXA(value, value…)
value: Any value or a collection containing any values. Date/time values or duration values can’t be mixed with other value types. If either of these value types is included, all values must be of the same value type. A string value can be included in a referenced cell, but can’t be entered directly as an argument to the function.
value…: Optionally include one or more additional values or collections.
Notes
A string value included in a referenced cell is given a value of 0. The boolean value FALSE is assigned a value of 0 and the boolean value TRUE is assigned a value of 1.
Examples |
|---|
=MAXA(1, 2, 3, 4) returns 4. =MAXA(A1:C1), where A1:C1 contains -1, -10, hello, returns 0. |