MAX function

Show All

Hide All

This article describes the formula syntax and usage of the MAX function (function: A prewritten formula that takes a value or values, performs an operation, and returns a value or values. Use functions to simplify and shorten formulas on a worksheet, especially those that perform lengthy or complex calculations.) in Microsoft Excel.

Description

Returns the largest value in a set of values.

Syntax

MAX(number1, [number2], ...)

The MAX function syntax has the following arguments (argument: A value that provides information to an action, an event, a method, a property, a function, or a procedure.):

• Number1, number2, ...    Number1 is required, subsequent numbers are optional. 1 to 255 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 counted.
• 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.
• If you want to include logical values and text representations of numbers in a reference as part of the calculation, use the MAXA function.

Example

The example may be easier to understand if you copy it to a blank worksheet.

How do I copy an example?