How to round percentages to the nearest tenth in excel

[Pages:2]How to round percentages to the nearest tenth in excel

How do you round to the nearest percentage. How to round to the nearest tenth in excel. How to round to the nearest tenth. How do you round to the nearest whole percentage.

Normally we can adjust a percentage value's decimal places with the Increate Decimal feature or Decrease Decimal feature in Excel. However, after adjusting, the actual value showing in the formula bar doesn't change at all (See below screenshot). So how to round percentage values and let both actual value and displaying value with two decimal places? This article will introduce you some solutions. Round up/down percentage values to two decimal places with formulas 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: Round up/down percentage values to two decimal places without formulas 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: Round percentage values to two decimal places with/without formulas In this section I will recommend Kutools for Excel's Operation utility to round percentage values to specific decimal places with or without formulas, and overwrite original percentage values in Excel. Please do as follows: 1. Select the percentage values you will round, and click Kutools > More (in Editing group) > Operation. 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: If uncheck the Create formulas option: If check the Create formulas option: (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: Demo: round percentage values to two decimal places 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. Related articles: Comments (0) No ratings yet. Be the first to rate! Excel is one of the best tools to make complicated works easier with the help of simple formulas. It also helps us to round off complicated numbers with multiple decimals. Let's find out how. Figure 1 Formula: =Round(number,number_digits) or =Round(A2,B2) Column A has the numbers that need to be rounded off and Column B has the number of decimals up to which we want to round off the original number. Enter the formula =Round(A2,B2) in C2. Copy cell C2, select column C and select the option of "pasting formulas" to apply the formula in every cell of C. Excel will round off the original number when the number of decimals to be rounded is placed in column B.

Figure 2 Digits before the decimal point are integers and digits after the decimal point are decimals. To round up to the nearest 10 in decimals, we'll write 1 in decimal column. We'll write 2 in decimal column to round up to nearest 100 in decimals. Figure 3 To round up the integer to the nearest 10, write -1 in the B cell next to original number. Write -2 to round up the integer up to nearest 100. Figure 4 Formulas: =RoundUp(number,number_digits) =RoundDown(number,number_digits) Total of the rounded numbers is 2680.66 Put 0 in the next cell of the number to remove decimals from the total. To take the upper value. We can write formula =RoundUp(number,number_digits) For the lower value, write =RoundDown(number,number_digits) Figure 5 Another way to increase or decrease decimals or to round off the original number is to simply click the option of increase/decrease decimal in the lower right corner of the "Number Section" in the toolbar. Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download