MAXA

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.

See alsoMAXMINA
Morty Proxy This is a proxified and sanitized view of the page, visit original site.
Полезна?
Ограничение на знаците: 250
Ограничението за знаци е 250.
Благодарим ви за обратната връзка.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.