Related Topics:
	Function Wizard Functions

MAX

Description: Returns the largest number in a set of values. The set can be defined by entering the values separated by commas, or by entering the references for a range of cells. For example, =MAX(1,2,3,4) returns 4 while =MAX(A1:A4) returns the largest value in rows 1 through 4 of column A.

Syntax: MAX(Number1, Number2,...)

• Number1, Number2, ... are 1 to 30 numbers for which you want to find the maximum value.

Remarks:

• Arguments can either be numbers or names, arrays or references that contain numbers.

• Logical values and text representations of numbers that you type directly into the list of arguments are considered.

• If an argument is an array or reference, only numbers in that array or reference are used. Empty cells, logical values or text in the array or reference are ignored.

• If the arguments contain no numbers, MAX returns 0 (zero).

• Arguments that are error values or text that cannot be translated into numbers cause errors.

Example:

If A1:A5 contains the numbers 10, 7, 9, 27 and 2, then:

• MAX(A1:A5) = 27 [the largest of the numbers in the reference]

• MAX(A1:A5, 30, 19) = 30 [the largest of the numbers including those in the reference]