The following article guides you in detail how to calculate the average in Excel.
There are 2 ways to calculate an average:
- Calculate the average value according to the usual calculation formula.
- Calculate the average value using the Average function.
1. Calculate the average using the calculation formula
For example, there are transcripts that calculate the average of 3 subjects of the student:
- In the cell to calculate, enter the formula: = (E6 + F6 + G6) / 3
- Press Enter to get the results:
Here the odd average has too many decimal places you need to reformat for easy viewing. Right-click the cell containing the average score -> select Format Cells .
The dialog box appears to select the data type number, in the Decimal places section select the number of digits for the decimal part, for example, here choose 2 decimal places. Click OK to confirm your selection:
- Finally copying the formula to the remaining values results:
2. Calculate the average value using the Average function
In the cell to calculate enter the formula: = Average (E6, F6, G6)
In addition, with the Average function, you can enter parameters by selecting the data area to calculate the average value:
Pressing Enter results:
Copying the formula for the remaining values results in:
Above is a detailed guide on how to calculate an average in Excel. Good luck!