How to Use Excel MAX Function (Examples + Video)

Excel MAX Function (Example + Video)

Excel MAX Function

When to use Excel MAX Function

MAX function can be used when you want to get the largest value from a set of values.

What it Returns

It returns the largest value from a set of values.

Syntax

=MAX(number1, [number2], …)

Input Arguments

  • number1 – the first number from a set of values from which you want to get the maximum value.
  • [number2], .. – (optional) second number from a set of values from which you want to get the maximum value. Up to 255 arguments can be used in the MAX function.

Additional Notes

  • Empty cells, logical values, or text in the array or reference are ignored.
  • Arguments that are error values or text that cannot be translated into numbers cause errors.
  • Arguments can either be numbers or names, arrays, or references that contain numbers.
  • Logical values and text representations of numbers that you type directly into the list of arguments are counted.
  • 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, MAX returns 0 (zero).

Excel MAX Function – Live Example

Excel MAX Function – Video Tutorial

Related Excel Functions:

Other articles you may also like:

Excel Ebook Subscribe

FREE EXCEL BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

Leave a Comment