Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Statistical > MIN
 

MIN(number1, number2 [,number3] [,…])

 
 Returns the smallest number in a set of values.

 number1The first number.
 number2The second number.
 number3The third optional number.

 REMARKS
 
  		• The arguments can be numbers, empty cells, logical values or text.
     
  		• If an argument is an array or cell reference, then only the numbers are used.
     
  		• If an argument is an array or cell reference, any empty cells, logical values or text in the array or reference are ignored.
     
  		• If an argument is an error value or is text that cannot be translated into a number, then ?? is returned.
     
  		• If the arguments contain no numbers, then 0 is returned.
     
  		• You can have a maximum of 30 arguments.
     
  		• If you do not want to include arguments that are text or logical values you can use the MINA() function.
     
  		• MINIF() - Returns the minimum value in a range of values that match a certain condition.

     EXAMPLES
     
     A
    1=MIN(5,2,6,9) = 2
    2=MIN(2,4,6,8) = 2
    3=MIN(2,"4","6",8) = 2
    4=MIN({5,4,3,2,1}) = 1
    5=MIN({"some","text"}) = 0
    6=MIN("some text") = #VALUE!
    		 
     Functions - M | Index - M | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top