Leading the way in Microsoft Office Development
 Home|

Excel

|Word|PowerPoint|Consultancy|Feedback|Contact 
 Excel > Functions > Statistical > MAX

 

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

 
 Returns the largest number in a set of values.

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

 REMARKS
 
  • You can specify arguments that are numbers, empty cells, logical values, or text representations of numbers.
     
  • Arguments that are error values or text that cannot be translated into numbers cause errors.
     
  • If an argument is an array or reference, only numbers in that array or reference are used.
     
  • Any empty cells, logical values, or text in the array or reference are ignored.
     
  • 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 MAXA() function.
     
  • MAXIF() - Returns the maximum value in a range of values that match a certain condition.

     EXAMPLES
     
     A
    1=MAX(5,2,6,9) = 9
    2=MAX(2,4,6,8) = 8
    3=MAX({5,4,3,2,1}) = 5
    4=MAX("some text") = #VALUE!
     

     Functions - M | Index - M | Office Online 2003 | Office Online 2007 

     Copyright © 2010 Better Solutions Limited. All Rights Reserved.Top