Regarding (0) with average in the merge word document, I, could not get any clue to solve.
Hopefully, I am still trying to solve the problem.
Thands and Regards,
Usually we can easily calculate the average of specific range with the AVERAGE function in Excel. However, the average may contains multiple decimal places as left screen shot shown. Sometimes you may want to keep the same decimal places as original numbers, or just remove the decimal places. Here I will introduce several formulas to average range with rounding in Excel.
Office Tab: Bring powerful tabs to Office (include Excel), just like Chrome, Safari, Firefox and Internet Explorer. Save you half the time, and reduce thousands of mouse clicks for you. 30-day Unlimited Free Trial
Kutools for Excel: Save 71% of your time and solve 82% Excel problems for you. 300+ advanced tools designed for 1500+ work scenario, make Excel much easy and increase productivity immediately.60-day Unlimited Free Trial
Actually we can change any numbers' decimal places with the Increase Decimal command or Decrease command in Excel easily.
1. Select a blank cell, for example Cell C3, enter the formula =AVERAGE(A1:A7) (A1:A7 is the range you want to calculate average) into it, and press the Enter key.
2. Select the cell with the average you just calculated (Cell C3 in our case), and then click the Increase Decimal button or Decrease Decimal button on the Home tab to round the average.
You can also combine the Round function and Average function to average a range with rounding in Excel.
Select a blank cell, for example Cell C3, enter the formula of =ROUND(AVERAGE(A1:A7),1) into it, and press the Enter key.
(1) In the formula =ROUND(AVERAGE(A1:A7),1), the A1:A7 is the range you want to calculate the average, and 1 means you want to round the average to only one decimal place, and you can change them based on your needs.
(2) For rounding up the average, please apply this formula =ROUNDUP(AVERAGE(A1:A7),1) .
(3)For rounding down the average, please apply this formula =ROUNDDOWN(AVERAGE(A1:A7),1).