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






  1. Microsoft Office Excel 2007 Tutorial
  2. Statistical functions
  3. MAX
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