# MAX

## 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.

### 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.

### MIN

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

### 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.