Excel Function : MAX

Download now!

Excel Function : MAX




Returns the maximum value in a list of arguments

Microsoft Excel Reference Page


Syntax and Description of the MAX Excel Function

The MAX function in Excel returns the largest value from a range of cells. The syntax for the MAX function is: =MAX(number1,number2,...) For example, if you wanted to find the largest value from cells A1 to A5, you would use the following formula: =MAX(A1:A5)

About MAX Excel Function

MAX is a function that returns the maximum value in a given range. For example, if you have a range of cells that contain numbers, you can use the MAX function to find the largest number.