For this, Add the ROUND function once we apply the AVERAGE. This will give the round figure result instead of a figure with decimal digits. We can get more precise results if we use AVERAGE with ROUND. This proofs the exactness of the formula we used. For this, select the cells and go down.Īs we can see above, it shows the same average as 33.6 for selected cell count 10. We can also check at the bottom of the excel sheet whether showing the same average. As we can see, the average of selected cells is 33.6, as shown below. Here we have selected the range from cell B2 to B11 cell, as shown below.Īnd then press Enter to get the result. To complete the syntax, select the range of cells for which we need to calculate the average. Now type AVERAGE and select the exact function, as shown below.Īs we can see, the syntax of the selected function is also seen. Now type = (Equal sign) to go in edit mode of that selected cell. For this, go to the cell where we want to see the output. This is a simple and quick way to get the required result. We will consider the same data which we have seen above for taking an average. We can see the total selected cells, the sum of all the numbers, and the selected numbers’ average. Many people already notice this the same result will be visible at the bottom of the excel sheet, as shown below. After that, click on OK.Īs we can see, we got the average of the selected range as 33.6 for the selected range B2 to B11. Here we can select more than 1 range in a different number of cells. There, select the cells or range for which we need to find the average. Once we click on OK, it will take us to the Average Function Argument window. We can also locate the Average function in the Statistical functions category from Or select a category box.Īs we can see above, after selecting the function, we will get the syntax suggestion also, which is highlighted in the box. From there, search for the Average function and then click OK. Or Go to Formulas Tab and Select Insert Function, as shown below.Īfter that, we will get an Insert Function box, as shown below.
0 kommentar(er)
