X
wikiHow is a “wiki,” similar to Wikipedia, which means that many of our articles are co-written by multiple authors. To create this article, volunteer authors worked to edit and improve it over time.
This article has been viewed 11,442 times.
Learn more...
Excel is such a powerful piece of software as there are many different functions and formulas available for you to use. This article will cover three of the most commonly used functions in Excel: the MAX, MIN and AVERAGE functions.
Steps
Method 1
Method 1 of 3:Using the MAX function
Method 1
-
1Start by typing an = sign in the cell where you would like to insert the MAX function.
-
2Type the word MAX followed by an open bracket.
-
3Select all of the cells which you would like to apply the MAX formula to. This will return the maximum value from any of the cells which you select.
-
4Press Enter. You should have now successfully inserted the MAX function. It will display the maximum value in the fields you selected.
Method 2
Method 2 of 3:Using the MIN Function
Method 2
-
1Start by typing an = sign.
-
2Type the word MIN followed by an open bracket.
-
3Select all of the cells containing numbers, from which you would like to have the minimum value displayed.
-
4Press Enter. You should have now inserted the MIN function, and it will display the minimum value from the fields you selected.
Method 3
Method 3 of 3:Using the AVERAGE function
Method 3
-
1Start by typing an = sign, like with all formulas in Microsoft Excel.
-
2Type the word AVERAGE followed by an open bracket.
-
3Select the cells of data from which you would like to calculate the average value.
-
4Press Enter. You have now inserted the Average function, and it will display the average value of the numbers in the fields you selected.
