MAX

Returns the largest number in a given list of arguments. If an expression references a range of cells, all the cells in the range are compared.

Syntax

MAX(expression,{expression},...)

Arguments

expression - numbers or references to compare.

Examples

MIN(3.14,-2,2) = 3.14

MIN(A2..B5,200)