Return the largest value in Excel
Returns the maximum value in a list of arguments, ignoring logical values and text


Return the largest value.


The Excel MAX function returns the numerical with the highest value as per given reference of cell range.
For example, if A1:A5 contains a list of numbers (2,8,10,5,6) in a column and user want to find the largest number, the formula can be =MAX(A1:A5), returns 10.


=MAX (number1, [number2], …)


number1 – First number or range of cells containing numerical values
number2 [optional] – Second number or range of cells containing numerical values.
Up to 255 numbers arguments to find the maximum value.

Return Value

The largest Integer

Key Notes

  • The MAX function returns the largest among the reference cell.
  • Apply the MIN function to find the lowest value among a data set.
  • Arguments can either be numbers or names, arrays, or references that contain numbers.
  • MAX returns 0 (zero) if none of the arguments listed value is numeric.
  • The function ignores empty cells.

Keep Reading Similar Functions:

Find the average of numbers in Excel


The AVERAGE function returns an average of numbers positioned in one or multiple ranges, =AVERAGE(5,15,30) add numbers and divide by 3, and returns 16.67.

Read More »
Return the smallest value in Excel


The MIN function returns the smallest numerical with the lowest value as per given reference of cell range.

Read More »
To add multiple numbers in Excel


The SUM function returns a number after adding multiple numeric arguments together =SUM(5,10,15) the Excel add numbers together and returns 30.

Read More »