**Home ► Excel Functions ► 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**

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.

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.

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**

**Conclusion**

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