Max Function In Excel | Find Largest Value from Table

The MAX function in Excel returns the largest numeric value in a range of cells. you can easily extract the largest value / number out of thousands and millions of values ​​typed in the sheet of MS EXCEL.

Syntax

MAX(number1, [number2], ...)

We can also use the Max function in such a way as can be seen in the image below.

Example 1

=MAX(45,32,56,78,23) 

Example 2 

=MAX(A2:A9) and then press the enter button of the keyboard.