=MAX(A2:A6, 30) returns the largest of the numbers above and 30 : MAX « Statistical functions « Microsoft Office Excel 2007 Tutorial






Input the formula: =MAX(A2:A6, 30). Press Enter to get the result.
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