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

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

 
 Returns the smallest number in a set of values.

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

 REMARKS
 
  		• This is identical to the MIN() function except that text and logical values are included.
     
  		• You can specify arguments that are numbers, empty cells, logical values, or text representations of numbers.
     
  		• Arguments that are error values cause errors.
     
  		• If an argument is an array or reference, only values in that array or reference are used.
     
  		• Empty cells and text values in the array or reference are ignored.
     
  		• Arguments that contain True evaluate to 1.
     
  		• Arguments that contain False evaluate to 0.
     
  		• Arguments that contain text evaluate to 0.
     
  		• If the arguments contain no values, then 0 is returned
     
  		• You can have a maximum of 30 arguments.
     
  		• MINIF() - Returns the minimum value in a range of values that match a certain condition.

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

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