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.
The syntax of the MAX function is as follows:
STEP 1 - First of all, open that MS EXCEL sheet in your computer, inside which you have to extract the biggest value out of all the values.
STEP 2 - After opening the sheet of Ms Excel, you select a cell with your mouse inside the sheet and then apply the formula of Max.
First put the sign of = and then type Max (after that select the area / cells in the table from which the maximum value is to be extracted and then press the enter button).
Example =MAX(A2:A9) and then press the enter button of the keyboard.
As soon as you press the enter button, the maximum value will appear in front of you in the cell where you have applied the Max formula. As can be seen in the above image.
#2 Method Max Function
We can also use the Max function in such a way as can be seen in the image below.
Downland Excel Practice Sheet
