Microsoft Excel MAX Function Help
EMAGENIT Home page

Call us at:   1.805.498.7162     1.805.558.9277--

Learn about how we can help your company or yourself achieve your Microsoft Excel training or self-study goals Visit our free Microsoft Excel and Microsoft Excel VBA resource center Learn how we can help save your company money with our innovative software solutions Visit out VBA code center for code that can save your company money Learn about our Excel Add-In software that can save your company time and money View our customer list from our 12 years in business Phone numbers, request form and email address Learn about EMAGENIT View our training schedule for Microsoft Excel and Microsoft Excel VBA

 

MAX Function Examples

MAX Function Definition

Returns the largest value from a worksheet range or set of values.

MAX Function Syntax

=MAX(number1,number2,...)

MAX Function Argument Definitions

number1, number2, ...:  These are 1 to 30 numbers for which you want to find the maximum value. They can be cell references like A1, range references like A1:A10 or cell names and range names. They can even be formulas and other functions.

MAX Function Tips

  • The arguments for this function can either be numbers or names, arrays, or range references that contain numbers.
  • You can type logical values and text representations of numbers directly into the argument list and they will be counted.
  • If an argument is range reference or an array, only numbers the numbers are analyzed. Empty cells, logical values and text are ignored.
  • Any arguments that produce error values or text that cannot be translated into numbers can cause errors.
  • If you want to include logical values and text representations of numbers in a reference as part of the calculation, try using the MAXA function.