Related Topics:

Spreadsheet Math Functions

Formulas Tab and Insert Function

Data Entry Tips for Functions

Function Wizard

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,...)

Remarks:

Example:

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

 

© 1992-2016. ReliaSoft Corporation. ALL RIGHTS RESERVED.

E-mail Link