MAX

Returns the largest value in a set of values.

Syntax

MAX(number1, number2, …)

• number1, number2,…     are 1 to 30 numbers for which you want to find the maximum value.

Specifics

• Arguments can either be numbers, arrays, or cell references that contain numbers.
• If the arguments contain no numbers, MAX returns 0 (zero).

Examples

A	B	C	D	E	Formula	Description (Result)
10	7	9	27	2	=MAX(A2:E2)	Largest of the numbers (27)
					=MAX(A2,B2,C2,D2,E2,30)	Largest of the numbers and 30 (30)