=MIN(A2:A6,0) returns the smallest of the numbers above and 0 : MIN « Statistical functions « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Statistical functions
  3. MIN
Input the formula: =MIN(A2:A6,0). Press Enter to get the result.
Input the formula: =MIN(A2:A6,0)
21.47.MIN
21.47.1.MIN(number1,number2,...) returns the minimum value in a list of arguments
21.47.2.=MIN(A2:A6,0) returns the smallest of the numbers above and 0=MIN(A2:A6,0) returns the smallest of the numbers above and 0