#ref-menu
Abid Ullah
October 31, 2016
0
Microsoft's Excel program allows you to build spreadsheets with mathematical formulas that adjust data according to your instructions on an ongoing basis.
In this artical we describes the Formula syntax and usage of the "Max" function in Microsoft Excel.
Open Microsoft Excel on your Computer.
1. Click On :New" at the left side
2. And click on the "Create" button at the Rightside
Enter information and Data in the cells that you will Wan the MAX of.
- Enter the numbers in cells B2 through B13 of the worksheet.
- the number enter are 32, 53,44, 33, 45,66, 16, 65,54,34,34, and 41
Entering the formula “=SUM(B2:B13)” in cell B14.
Hit "Enter" to See the Result.
Find the "MAX" of the number you Enter.
You can place the "MAX" function in many ways due to the "MAX" fuction it will display the maximum value in the fields you selected.
- Click on an empty cell, such as B1,7 then type “=MAX(B2:B13)” And Click Ok.
- Click on any Empty cell Enter the range “B2:B13" and Click Ok.
Hit "Enter" to see the Result.
Hello, my name is Jack Sparrow. I'm a 50 year old self-employed Pirate from the Caribbean.