MAX « Statistical functions « Microsoft Office Excel 2007 Tutorial






21.44.MAX
21.44.1.MAX(number1,number2,...) returns the maximum value in a list of argumentsMAX(number1,number2,...) returns the maximum value in a list of arguments
21.44.2.=MAX(A2:A6, 30) returns the largest of the numbers above and 30