Excel: Min and Max

[embedyt] http://www.youtube.com/watch?v=cPn1gGjD4ZM[/embedyt]

Max function returns the largest value in a set of values.

Syntax

MAX(number1, [number2], ...)

The MAX function syntax has the following arguments:

• Number1, number2, ...    Number1 is required, subsequent numbers are optional.

Note:

• If the arguments contain no numbers, MAX returns 0 (zero).


• Arguments that are error values or text that cannot be translated into numbers cause errors.


• If you want to include logical values and text representations of numbers in a reference as part of the calculation, use the MAXA function.MIN functions returns the smallest number in a set of values.
  
  
  

  Syntax

  
  MIN(number1, [number2], ...)
  
  The MIN function syntax has the following arguments:
  

  
  
  • Number1, number2, ...    Number1 is required, subsequent numbers are optional.
  
  

  
  
  
  

  Note:

  
  

  
  
  • If an argument is an array or reference, only numbers in that array or reference are used. Empty cells, logical values, or text in the array or reference are ignored.If the arguments contain no numbers, MIN returns 0.
  
  
  • Arguments that are error values or text that cannot be translated into numbers cause errors.
  
  
  • If you want to include logical values and text representations of numbers in a reference as part of the calculation, use the MINA function.