HomeExcel Functions ► Excel MAX Function

Syntax For Excel MAX Function

What is the use of Excel MAX Function?

Use Excel MAX Function to get the largest value from a specified set of values. In simple words, It will return the highest value from a set of numbers given. For example, from 10, 20, 25, 30 it will return 30 in the result as 30 is the largest value from the given set of values.

Syntax for Excel MAX Function

MAX(number1, [number2], …)

number1 A number, a cell which has a number or a range of cells having numbers from which you want to get the largest number. [Required]

[number2] A number, a cell which has a number or a range of cells having numbers from which you want to get the largest number. [Optional]

More Information on Excel MAX Function

  • You can refer to a single cell, a named range, a range of cells or an array.
  • If there are no numbers in specified arguments it will return 0.
  • If there is text or an error value in the argument, it will return #N/A.
  • If you directly enter a logical value or a text which represents a number into the function, that will be counted.
  • It will only consider numeric values. Empty cells, text & logical values in a reference or in an array will be ignored.
  • The maximum number of arguments you can refer is 255.

Examples to understand Excel MAX Function

Examples For Excel MAX Function directly into the function

In above example, I have entered numbers directly into the function by separating them using a comma. You can also enter a number by using double quotation marks. It will consider them as a number.

Examples For Excel MIN Function Using A Range

In above example, I have refers to a range & it has return 1861 in the result as the largest value. You can also refer to an array as well.

Examples For Excel MAX Function With Error Value

In above example, I have encountered with an error value & function has returned an error value in the result.

You can use max function different ways in other function like IF & VLOOKUP.

Download Sample File

Download Sample File To Learn Excel MAX Function

More Tips Related With Excel MAX Function

Conclusion

Use Excel MAX Function to get the largest value from a set of numbers you have specified. Learn more about MAX from here.

Related Function

Min

Blog | Excel Functions