MAX

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

Rational

Return the largest value.

Description

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.

Syntax

=MAX (number1, [number2], …)

Parameters

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:

To add multiple numbers in Excel

SUM

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 »
Find the average of numbers in Excel

AVERAGE

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

MIN

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

Read More »