Use the MAX Function for MS Excel

Use the MAX Function :

• Enter the following data into Excel spreadsheet. 
• Click on cell C8 or any other cells where the results will be displayed. 
• From the Formulas tab,  in the Function Library group, click the MAX in the list to bring up the function's dialog box. 
• From the Max Function Arguments dialog box displayed; type C1:C6 or you can drag the mouse from cell C1 to C6. 
• Click OK.  The result will display on the cell C8. 
• If you choose the different ranges,  the following result will display. 

                 =Max(C1,C2) would return 632.

                   =Max (C3:C5,896) would return 896. 

                   =Max (C2:C6) would return 808.