MAX

Maximum numeric value in cells, ranges, or data fields. Non-numeric values (text, blanks, errors) are ignored.

Function syntax

MAX(input1, ...)

Arguments:

• input1, …: One or more numbers, cells, ranges, or data fields.

Examples

• MAX(C10:E15) - Maximum numeric value in C10:E15.
• MAX(revenue{}) - Maximum value in the revenue field.
• MAX(revenue{continent{“Asia”}}) - Maximum revenue value where continent is Asia.
• MAX(500, revenue{continent{“Asia”}}, cost{country{“France”}}) - Maximum across the number 500, Asian revenue, and French cost combined.
• MAX(A1:A5) - If A1:A5 contains 10, "hello", 20, blank, 5, returns 20. Text and blanks are ignored.