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.