How to use the max function in excel

How to use excel's max function: First enter the "maximum number", click "fx" to enter "Insert Function"; then select "Statistics", and for the "Statistics" function, select the "MAX" to be used "; Finally click the "OK" button.

The operating environment of this article: Windows 7 system, Microsoft Office PowerPoint 2020 version, Dell G3 computer.

How to use the max function of excel:

1. Open excel and write some data as the operation object to find the maximum value

2. Make some modifications, enter the "maximum number", then place the cursor in a cell behind the "maximum number", click "fx" in the red box to enter the function Setting page

#3. After clicking "fx", you will enter the setting page of "Insert function". This is where you can find the function we want to use

4. The max function to be used belongs to the "Statistics" category. You need to select "Statistics" in the drop-down box behind "Select Category"

##5. After selecting "Statistics", the functions listed under "Select Function" are all functions related to "Statistics". Select the "MAX" to be used, and then click "OK" on the lower right.

6. After completing step 5, enter the "Function Parameters" setting interface and delete the content after Number1 to select our range

7. Assuming that the range to be searched is all the data in this table, then the first parameter to be set should be the first data in the table. Click the value of the first data with the mouse. You will find that the first parameter is automatically filled in for us in the input box behind Number1,

8. Then manually enter the colon after the first parameter. Indicates range.

9. What we need to do now is to set the last parameter. Just click the last data of the form with the mouse, and excel will automatically fill it in for us. The value of this parameter.

#10. All parameters have been set. Now click the "OK" button to close the "Function Parameters" setting dialog box and return to the form. This is It is found that the maximum value has been found.

The above is the detailed content of How to use the max function in excel. For more information, please follow other related articles on the PHP Chinese website!