We can apply ROUND function, ROUNDUP function, or ROUNDDOWN function to quickly round up/down percentage values to specified decimal places in Excel. Please do as follows:

Select a blank cell beside the percentage values, says Cell D2, type the formula =ROUND(C2,4) (C2 is the percentage value whose decimal places you will change) into it, and then drag this cell’s AutoFill Handle to the range as you need. See screenshot:

Notes:
(1) For rounding up percentage values to two decimal places, please apply this formula =ROUNDUP(C2,4);
(2) For rounding down percentage values to two decimal places, please apply this formula =ROUNDDOWN(C2,4);
(3) For rounding percentage values to N decimal places, please apply this formula =ROUND(C2, N+2). For example, you need to round to 1 decimal place, please change the formula to =ROUND(C2, 3).
(4) If rounding results are not in percentage format, please select the rounding results and click the Percentage button; if rounding results are not with specific decimal place, please select the rounding results, and click the  Increase Decimal button or  Decrease Decimal button. See screenshot:

If you have installed Kutools for Excel, you can apply its Round utility to easily round up/down percentage values to specified decimal places without formulas. Please do as follows:

1. Select the percentage values you will round, and click Kutools > Round.

2. In the opening Round without Formula dialog box, type 4 into the Decimal place box, select one option as you need in the Option section, and click the Ok button. See below screenshot:
And now all selected percentage values are rounded up/down/even to two decimal places.

Notes:
(1) For rounding percentage values to N decimal places, please enter N+2 into the Decimal place box. For example, for rounding to 1 decimal places, please enter 3 (=1+2) into the Decimal place box.
(2) If rounding results are not in percentage format, please select the rounding results and click the Percentage button; if rounding results are not with specific decimal place, please select the rounding results, and click the  Increase Decimal button or  Decrease Decimal button. See screenshot:

2. In the Operation Tools dialog box, please click to highlight the Rounding in the Operation box, type 4 into the Operand section, and click the Ok button.

Notes:
(1) For rounding percentage values to N decimal places, please enter N+2 into the box in the Operand section. For example, for rounding to 1 decimal places, please enter 3 (=1+2).
(2) You can round the percentage values with or without formulas:

(3) If rounding results are not in percentage format, please select the rounding results and click the Percentage button; if rounding results are not with specific decimal place, please select the rounding results, and click the  Increase Decimal button or  Decrease Decimal button. See screenshot:

Easily add percentage sign to numbers without multiplying 100 in Excel

Normally we add percentage sign to numbers by changing number formatting, and this method will show 6.1 as 610%. But Kutools for Excel’s Add Text utility can help you easily add mass percentage signs to multiple numbers without multiplying 100.

Average range with rounding in Excel

Round numbers (up/down) to hundreds, thousands, or millions in Excel