MAX(number1,number2,...) returns the maximum value in a list of arguments : MAX « Statistical functions « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Statistical functions
  3. MAX
Input the formula: =MAX(B2:B6). Press Enter to get the result.
Input the formula: =MAX(B2:B6)
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