How to add, or SUM, a column of percentages using an Excel formula so that the total comes to 100%. If you read this article before this update, then please note the section, Targeting the Fudge, that addresses my main concern about the technique I posted originally. Excel worksheet - Calculating Percent & Using Absolute ... Now to calculate percentage of total write this Percentage formula in cell C4 and drag it down: You will see fraction numbers. The Houston Chronicle elaborates on a simple method that can be used in versions of the software up to MS Excel 2013. Formulas are Shown in Excel's Formula Bar. Right-click on formula cells, then choose Format Cells. How to show percentage in Excel - Ablebits How to Calculate a Percentage of a Number in Excel If you want to calculate a percentage of a number in Excel, simply multiply the percentage value by the number that you want the percentage of. So, 95 divided by 350 equals 0.27. An alternative, but more long-winded calculation, would be to calculate 10% of the number and then subtract it from the original number, with one of these formulas: =A2- (A2*10%) =A2- (A2*0.1) This will have exactly the same result and, as in the . Solve examples using the above formula: 1. Statistical Functions in Excel 2013 can address various statistical problems pertaining to Averages and Measures of Spread. How to Calculate percentage change in Microsoft Excel ... View all Excel Functions. Excel 2013 Posts 68. Tags: Calculate Percentage in Excel. Open the Excel sheet that contains your data. To calculate percentage difference you take the absolute value of the difference between two numbers. To calculate percentage difference you take the absolute value of the difference between two numbers. Repeat this process as many times as needed with other numbers for which you want to find the percentage . Using the historical data above, you should calculate the trend percentages using 2017 as the base year, so everything in 2017 must be 100%. Steps Download Article. 5. You will calculate the count of wins as a percentage for the count of athletes based on the events. Try typing =4+4 as your very first formula, and press enter to return the result. Copy the formula in the remaining cells to get the percentage change of profit margin for the rest of the data. Percentage is one of the most common ways of expressing a proportion. Calculate the Percent Difference. The go to the number tab and use the dropbox to select percentage.On this tab, you can also use the decimal arrow keys to select the number of decimal places you want. Excel: Calculate a Running Percentage of Total - Excel ... This page is an advertiser-supported excerpt of the book, Power Excel 2010-2013 from MrExcel - 567 Excel Mysteries Solved. Its submitted by giving out in the best field. The format is =AVERAGE(AA:BB) where AA is the first cell in the range and BB is the last cell in the range. I.e. This feature was introduced in Excel 2010, so applies only to 2010 and later versions. The same calculation can be done by using excel simple formulas. To change the decimal to a percentage, right click the cell and choose "Format Cells" from the drop-down menu. Let us consider a simple example. Because of the way Excel handles percentages, it sees these formulas as exactly the same thing. To enter a percentage in Excel, execute the following steps. Now we can combine the two functions to determine the student's final grade based on their scores and the weights of each score. The percentage change is usually the difference returned from the subtraction of the two percentages: I.e. Same thing can be done form Number section of Home tab. First, enter a decimal number. Insert your two figures in columns A and B. In other Excel versions, there may be some slight differences in the described steps. Type =XX/YY into the cell, but use cell locations instead. To calculate the percentages in column D of the Excel spreadsheet, enter the following formula (and then press Enter): =C2/B2. The mathematical formula for percentages is that there is a value being expressed as the fraction of a whole, then multiplied by 100. We'll walk through several examples, including turning fractions to percentages, and calculating percentage of total, increase . What I want is for each column to know the %change for each day ie by how much was the new value up/down based on the previous day. The go to the number tab and use the dropbox to select percentage. Now to convert them into percentage, select the cells and press CTRL+SHIFT+ (%). Countif and calculate the percentage of a specific value with formula. So, be aware of it before using them in your work. how to calculate percentages in excel 2013 youtube. The mathematical formula for percentages is that there is a value being expressed as the fraction of a whole, then multiplied by 100. This feature was introduced in Excel 2010, so applies only to 2010 and later versions. Mary didn't have an increase or decrease on Martha's sales over the same time period, they were just different. The following methods work for Microsoft 365, Excel 2019, Excel 2016, Excel 2013, Excel 2010, Excel 2007, Excel Online, Excel 2016 for Mac, and Excel for Mac 2011. Let's give a concrete example: for example, one day from the warehouse were sold 120 plane tablets, and in the next day - 150 ones. You can calculate the difference by subtracting your new earnings from your original earnings, and then dividing the result by your original earnings. This requires an even simpler mathematical . Learn how to represent data effectively for reports etc. The above %RSD example has been entered into the Excel formula bar and will calculate the percent relative standard deviation of the 5 value data set E6 to E11. Calculate Discounted Price. How to Manually Create an Average Formula in Excel 2013. It pertains to calculating students were present (which I indicate with a 'P'). Divide the given value by the total value and then multiply by 100. Finally, multiply the number you got by 100 to find out the percentage increase. Then divide it by the average of those two numbers and then multiple by 100 to get the percentage. We identified it from well-behaved source. Mary didn't have an increase or decrease on Martha's sales over the same time period, they were just different. Percent charts in Excel: creation instruction. For example, 95% is read as "Ninety-five percent" and is equivalent to 95/100 or 0.95. Calculate the percentage of children. This starts the formula. For example, if you want to calculate 25% of 50, multiply 25% by 50. Percent Change = (New Value - Old Value) / Old Value. Then divide it by the average of those two numbers and then multiple by 100 to get the percentage. In mathematics, a percentage is a number expressed as a fraction of 100. Type =(2500-2342)/2342, and then press RETURN . How to calculate percentages in Excel. In the below example, we have value 10 and 2, where 10 is divisible with 2. Last updated on 2021-07-06 by David Wallis. Let's get down to how we actually calculate the percentage of something. Say, you want to calculate the percentage of two values: Old value: -400. Here I will show 3 methods to calculate the percentage change of negative numbers in Excel but all of them will mislead you. Profit margin percent can be calculated using the above method. He needs to display the information on the chart. When we calculate percentage difference with formula in Excel, the answer we get is simply in number format. Suppose the user has data in absolute values. Learn Calculating percentages in Microsoft® Excel 2013 by following the steps shown in this video.-----. In theFormat Cellsdialog box, in the Categorylist, click Percentage. Add another copy of the Units field to the Values area, where it will become Sum of Units2. Basic Excel percentage formula. Here are a number of highest rated How To Figure Out Percentages pictures on internet. Hello! how to calculate percentages in excel 2013 youtube. As you probably remember from high school math class, a percentage is a fraction of 100 that is calculated by dividing the numerator by the denominator and multiplying the result by 100. Excel 2013 retains some legacy Functions from prior versions but in many instances provides newer Statistical Functions which supersede the previous versions. In my Excel 2013, I see 0% though I know with certainty it should be 0.2%. As a general rule averaging averages will give you dodgy numbers. To change numbers to a percentage in Excel using the Ribbon, click on the Ribbon, make sure you are on the home Ribbon tab. How to calculate the percentage of deviation in Excel. Step 1 - Review percent - Before showing how to calculate percent with Excel, let's review how to calculate percent.. A number divided by a second number and multiplied by 100 expresses what percent the first number is of the second number. Excel formula for percentage change between two percentages. However, I obviously want to calculate the percentage. For example, if you want to calculate 20% of 500, multiply 20% by 500. The job of the VLOOKUP is to find the rep's sales amount in the rate table, and return the corresponding payout rate. Result. 06-07-2013, 06:51 AM #3. On the Hometab, in the Numbergroup, click the icon next to Numberto display the Format Cellsdialog box. When the dialog box opens, choose "Percentage" from the list, then click "OK.". 3. Calculate Ratio by using Simple Divide Method. Re: How do I find the percentage between three numbers? Note: if you're still paying 75%, you're not paying 25% (the percentage discount). Note: This tutorial uses Excel 2013. So you can use this method here. Example 10 / 100 = 10% 1/2 = 50% The average is not 30% ((10+50)/2). Percentage = Marks scored/Total score x 100 e.g. You can easily apply the formula to subsequent rows by double-clicking the bottom right corner of the cell (in this case: D2). On the Home tab, in the Number group, click the percentage symbol to apply a Percentage format. Calculate Excel percentage difference between two numbers (using formula) Save Saved Removed 0. Hi I'm trying to calculate the percentage change between values on a pivot table. How to Calculate a Percentage of a Number If you want to calculate a percentage of a number in Excel, simply multiply the percentage value by the number that you want the percentage of. final value (with discount applied) = initial value - ((discount percentage * total value)/100) Other forms of calculating discount in Excel. Simple percentage formula in Excel. New value: 200 To find the count of wins as a percentage for the count of athletes based on events at first, you will try with a calculated field. To show percentage of total in an Excel Pivot Table, create your PivotTable with the information you want summarized, and then follow the steps below. Excel will output 8, but the formula is still behind the scenes in the spreadsheet. For example, apply the percent format to an empty cell and then type 0.2 into it. Excel Percent Style button and its effect. The go to the number tab and use the dropbox to select percentage.On this tab, you can also use the decimal arrow keys to select the number of decimal places you want. To find the average percentage of the two percentages in this example, you need to first divide the sum of the two percentage numbers by the sum of the two sample sizes. What do you see? Click anywhere in your PivotTable and open the PivotTable . On a 15-day vacation, Mr. A spent 10 days in his hometown and 5 days in the USA. Note that you can also manually create an Average formula. I can do this the normal way by calculating %change and get the results but when I come to copy the formula (by dragging it down the rest of the columns) it . 6. You can always see the structure of a formula in your spreadsheet by clicking on the cell, then checking the Formula Bar above the spreadsheet. Author . This is a shortcut to convert number into percentage. Do not trust my math! First of all, we need to prepare the data for the calculation of percentage change. 1) Calculate the % change of negative numbers by making the denominator absolute. If you want instead a simple number without a percent sign, just multiply by 100: = ( C6 / total) * 100 = ( C6 / $C$15) * 100 The result is a number like 36, 18, 12.9, etc. Click in the cell where you want the formula. Its submitted by giving out in the best field. In Excel, you can use three different charts, namely a pie chart, a doughnut chart and a bar chart to show percentages of a whole. Select the cell that contains the result from step 2. Next, divide that number by the starting value. We say you will this kind of How To Figure Out Percentages graphic could possibly be . To find the percentage change between two percentages we use the following formula: =Percentage change/ (first percentage+ second percentage)/2. Difference between Percentile & percentage function. Basic Excel percentage formula. To change numbers to a percentage in Excel using the Ribbon, click on the Ribbon, make sure you are on the home Ribbon tab. To see the percent difference between the Forecast and the Actual units, you can use a custom calculation. For example, what percentage of the plan is made, how many goods sold, which part of the students coped with the task . Step 2. After preparing the data, we'll calculate the difference between the values. Then, subtract the starting value from the current value. Images were taken using Excel 2013 on Windows 7. I just woke up and have not had a math class in years, but I think num/(max-min) is what you are looking for. Before you can find the RSD of a range, you'll need to use the STDEV formula to calculate the standard deviation. Right-click one of the selected cells, then click the Format Cells option. This is a shortcut to convert number into percentage. For the sake of clarity it is necessary to show the relative values of the data. Welcome to my Excel blog! But now I am a die-hard fan of MS Excel. The basic percentage formula is as follows: (Part/Whole)*100 = Percentage We're going to apply a formula that tells Excel to take 15% of 83 (or 12.45) and add it to our original . How To Figure Out Percentages. Select the cell where the weighted average should go (for us that's cell D15) and then type the following formula into the function bar. To calculate the percentages in column D of the Excel spreadsheet, enter the following formula (and then press Enter): =C2/B2. Kawser. This is the difference between one number, as your complete figure, and a smaller number. On the Home tab, in the Number group, click the percentage symbol to apply a Percentage format. The correct figure is . Calculate the sum The first step is to calculate the sum with the formula "=sum(cellX:cellY)" entered below the cell range of a sum. Register To Reply. One thing to note is that there isn't a function to calculate percentages. Result. Insert the below formula into the cell and hit enter. Copy and paste the formula into other cells as needed. How to Work With Excel Math Formulas (Guide to the Basics) trend business.tutsplus.com. Select Percentage, then click OK. When applying percentage formatting to numbers, Excel 2016, 2013 and 2010 display their rounded versions with no decimal places, which may cause some confusion. Whenever there is a decrease, the new value recorded is usually lower than the initial one. Article Summary X. Tip: you can also format the numbers as Percent Style using a keyboard shortcut: press Control-Shift-% in Windows or Command-Shift-% on the Mac. Want to master Microsoft Excel and take your work-from-home job prospects to the next level? Usually, we multiply the result with 100 in order to get the percentage difference in numbers. For this example our commissions plan looks like the following: Rep sells $0-$50,000, they earn 5%; Rep sells $51,000-$100,000, they . If marks are 80, 80/100 x 100 = 80%. Same thing can be done form Number section of Home tab. Here are a number of highest rated How To Figure Out Percentages pictures on internet. Highlight the range. 1. One thing to note is that there isn't a function to calculate percentages. Click anywhere in your PivotTable and open the PivotTable . Percent one-percentage two. I.e. Question: In Microsoft Excel 2010, how do I show the Totals as a percentage of the Grand Total in a pivot table? mixed. If you like this topic, please consider buying the entire e-book. Calculate a percentage of increase Click any blank cell. Examples of this include Percentile, Percent Rank, Quartile and . From this, we have the pivot table Count of Name and Count of Win. The best way to calculate percentages is to calculate for 1%. A, in our example, will be the whole number, while B will be our percentage. I guess I need to have a count of the occurrences of each number and then a total divided by numbers in column. Let's get down to how we actually calculate the percentage of something. The exam reflects how well you have done in the exam as an individual; the percentage score is calculated on the basis of the below-mentioned formula. We can calculate the percentage change in Excel using the formula below % of Difference = (New Value - Old value)/Old value. Jump-start your career with our Premium A-to-Z Microsoft Excel Training Bundle from the new Gadget Hacks Shop and get lifetime access to more than 40 hours of Basic to Advanced instruction on functions, formula, tools, and more.. Buy Now (97% off) > Other worthwhile deals to check out: Hope you understood how to calculate the Percentage margin profit of a set of values. Select the cell (s) containing the percentage symbol (s) that you want to remove. Using an Excel worksheet - Calculating Percent and Using Absolute Cell Reference . The percentage formula in Excel is = Numerator/Denominator (used without multiplication by 100). To change numbers to a percentage in Excel using the Ribbon, click on the Ribbon, make sure you are on the home Ribbon tab. Answer (1 of 7): Averaging percentages is a really bad idea. I have attached a sample. mixed. How to Use a Percentage Formula in Excel 2013 Open your Excel file. How to Total Percentages in Microsoft ® Excel. Now to convert them into percentage, select the cells and press CTRL+SHIFT+ (%). type the following formula into any Excel cell: =20%*500 Calculate a Percentage Change. You can easily apply the formula to subsequent rows by double-clicking the bottom right corner of the cell (in this case: D2). 1. How do you show a percentage change in Excel? I am using Excel 2007 and have a column of numbers that I want to calculate and display the percent of occurrences of each number. Note: to change the percentage in cell A1, simply select cell A1 and type a new percentage (do not type a decimal number). Accordingly, the values in column D are decimal values, with the Percentage number format applied. For net sales in the second year, take $12,025.80 from 2018, divide it by $10,106.50 from the base year and then multiply the result by 100 to get 118.99%. Hello, I wish to calculate the percentage of a range of cells (column), but only if they have a value other than '0' (some lazy conditional formatting on my part). Therefore, to find the percentage decrease we must calculate the decreases recorded first. To calculate the %RSD in Microsoft Excel a short formula must be used: = (STDEV(Data Range) / AVERAGE(Data Range))*100 = (STDEV(A1:A11) / AVERAGE(A1:A11))*100. Percent Change = (20000 - 15000) / 15000. =A2/B2&":"&"1″. This adds the range to the formula. Type = (STDEV ( into a blank cell. 10 out of 15 people were children. How To Figure Out Percentages. Percentage of Total In excel, the basic formula to calculate percentage is Excel percentage calculation: Part/Total = Percentage Images were taken using Excel 2013 on Windows 7. Simple percentage formula in Excel. So, 0.27 multiplied by 100 equals 27 or 27%. Take the above data for example, you can quickly find the percentage of a specific option with following formula. As you can see in the above snapshot first data percentage of profit margin is 8%. Excel: Calculate a Running Percentage of Total. Excel percentage formulas can help with many everyday applications. We can use this method when the larger value is divisible with the smaller value. type the following formula into any Excel cell: =25%*50 - which gives the result 12.5. How to Create a Check Mark Box in Excel. To convert the output to a percentage, either press "Ctrl+Shift+%" or click "%" on the Home tab's "number" group. To do this, first select one of the Total values that you wish to display as a percentage of the Grand Total. Select a cell that contains the Sum of Units2 label, and then type a more descriptive name, for example, % Diff. Here, in the above table, we've put some values that we are going to use to find the percentage difference between the orginal_values and new_values. Click the empty cell next to your percentage to tell Excel where we'll be displaying the result of our formula. This tutorial applies to calculating percentages in Excel 201. 1. Although there's no basic percentage formula in Excel, you can multiply a number by a percentage using a formula. The concept of rejection percentage means the difference between two numeric values in percent. The COUNTIF and COUNTA functions can be combined to get the percentage of a specific value in a range of data in Excel. I learn new ways of doing things with Excel and share them here. If you prefer, here you will find other formulas for calculating percentages using Excel or any other type of spreadsheet. By performing a simple calculation = 6/30*100, you get the answer as 20%. To show percentage of total in an Excel Pivot Table, create your PivotTable with the information you want summarized, and then follow the steps below. Converting fraction or decimal numbers into percentage - multiply by 100. We say you will this kind of How To Figure Out Percentages graphic could possibly be . Select the type of formatting that you would rather use, then click the OK button. Author Dave Bruns Excel Formula Training This is how we normally calculate percentages everywhere and in everyday life. Unless the denominators are the same, you're going to get a skewed result. Percent Change = 5000 / 15000. As with many functions in Excel, there is another way to this as well using the Ribbon - the top toolbar in Excel. You then multiply this decimal by 100 to get the average percentage. It took me some time to be a fan of Excel. Answer: In this example, we are displaying the Order IDs based on the "Sum of Quantity", but we want to show the Totals based on a percentage of the Grand Total. Step Three: Combine the SUMPRODUCT and SUM to Calculate the Weighted Average. For example, in addition to seeing completed check marks in a project, the spreadsheet can also instantly calculate the completion percentage for the project. To calculate percentage increase, start by writing down the starting value and the current value. The payout rate could be a flat dollar amount, percentage of revenue, percentage of quota, etc. Excel Percentile Function Percentage function. Excel can also help you calculate a percentage as a proportion. We identified it from well-behaved source. I want to display 107 is 1.2%, 108 is 2.5 %, etc. New smallbusiness.chron.com. Formatting percentages in Excel. Percent Change = 33.33%. The decrease is then divided with the initial value to get the ration of decrease. In the cell where the . Now to calculate percentage of total write this Percentage formula in cell C4 and drag it down: You will see fraction numbers. Now we will see how to solve these problems in an excel worksheet. 1. Excel formula for percentage decrease. Open the spreadsheet in Excel 2013. The result is 0.06746. 2. To display a percentage in Excel, use the Percentage number format, which will automatically display a decimal value as a percentage. 2. If you know the original price and the percentage discount, you can calculate the discounted price. You might also want to calculate the percentage change from one month to the next month. Recorded is usually lower than the initial value to get a skewed result < a href= '':., percent Rank, Quartile and Discount percentage < /a > step three: Combine the SUMPRODUCT and to... Percentage formula in the below formula into any Excel cell: =25 % * 50 - which gives result. Is still behind the scenes in the below formula into any Excel cell: =25 *... Excel will output 8, but the formula calculate a percentage format Rank, Quartile and introduced Excel. Formula cells, then choose format cells 95 % is read as quot! S ) that you would rather use, then click the percentage 2013, see.... < /a > 5 '' > How to Figure Out percentages pictures on internet here you will this of. Display the information on the chart the scenes in the best field walk through several,. As your very first formula, and a smaller number 2013 Posts 68 the are. On smallbusiness... < /a > calculate percentages - support.microsoft.com < /a calculate... P & # x27 ; ll walk through several examples, including turning fractions to percentages, and press (. Pivot table Count of Name and Count of Win right-click one of occurrences... Of those two numbers and then multiple by 100 to get the percentage increase or in. In theFormat Cellsdialog box, in the Categorylist, click the percentage show. By numbers in column D are decimal values, with the initial one you. = 10 % 1/2 = how to find percentage in excel 2013 % the average of those two numbers then! < a href= '' https: //onelib.org/find-circular-reference-in-excel-365? site=smallbusiness.chron.com '' > format how to find percentage in excel 2013! Lower than the initial value to get the percentage we get is simply in number applied. Then multiple by 100 CTRL+SHIFT+ ( % ) can also manually create average. Percentile, percent Rank, Quartile and percent & amp ; & quot ; and is to! Profit of a set of values consider buying the entire e-book before using them in your work submitted by Out! Slight differences in the spreadsheet ( using formulas ) < /a > calculate the percentage of a specific in... Averages will give you dodgy numbers described steps > step three: Combine the SUMPRODUCT and to... Label, and then a total divided by numbers in column you then multiply 100! Aware of it before using them in your work 80/100 x 100 = %. Percentile, percent Rank, Quartile and ) that you want to calculate in! Support.Microsoft.Com < /a > 5 / 15000 0.2 into it necessary to show relative! Any blank cell it before using them in your PivotTable and open PivotTable! Examples ) < how to find percentage in excel 2013 > step three: Combine the SUMPRODUCT and to. An average formula only to 2010 and later versions examples, including turning fractions to percentages, press... Two values: Old value: -400 one month to the values area, where will... 0.2 % percentage symbol ( s ) that you want to calculate percentages everywhere and in life... Percentages everywhere and in everyday life percentage Discount, you can also create... Being expressed as a general rule averaging averages will give you dodgy numbers with following into! Ctrl+Shift+ ( % ) the initial value to get the percentage decrease must! 0.27 multiplied by 100 to how to find percentage in excel 2013 the percentage of a specific option with following:... Turning fractions to percentages, and calculating percentage of the units field to the next month 15000. //Calcuworld.Com/Calculate-Discount-In-Excel/ '' > How to calculate percentages everywhere and in everyday life Categorylist click. Units2 label, and then type 0.2 into it unless the denominators are the same calculation can be done number..., for example, 95 % is read as & quot ; Ninety-five percent amp... Absolute... < /a > step three: Combine the SUMPRODUCT and SUM to calculate percentage increase or in... Then a total divided by numbers in column D are decimal values, with the initial.! Reports etc RETURN the result of highest rated How to calculate percentages - support.microsoft.com < /a Countif! % * 50 - which gives the result concept of rejection percentage means the difference between the Forecast and Actual. Them here 50, multiply the number you got by 100 equals 27 or 27 % the absolute! Be calculated using the above data for example, if you want to calculate percentages - How to solve these problems in an Excel formula so that the value. Pictures on internet 5 days in his hometown and 5 days in his hometown and days! Where 10 is divisible with the percentage my Excel 2013, I 0... Formulas are Shown in Excel | Discount percentage < /a > step three: the... Click the OK button to find the percentage Discount, you can quickly find percentage... Using Excel or any other type of spreadsheet gives the result from step.. Got by 100 to get the average percentage theFormat Cellsdialog box, in how to find percentage in excel 2013 example, if like! Three numbers in the number you got by 100 to find the percentage using an Excel formula so that total... This is the difference between the Forecast and the percentage see How to Figure Out graphic... Support.Microsoft.Com < /a > step three: Combine the SUMPRODUCT and SUM to calculate difference! Of clarity it is necessary to show the relative values of the Grand total scenes in the described steps say. And Count of the data I need to have a Count of and. Number you got by 100 to find Out the percentage of two:! The next month the PivotTable, % Diff, and then multiple by 100 you... < a href= '' https: //onelib.org/find-circular-reference-in-excel-365? site=smallbusiness.chron.com '' > How Figure. Cellsdialog box, in the cell where you want to calculate percentages - support.microsoft.com < >... 50, multiply 20 % by 50 Name and Count of the occurrences of each and. Numbers as percentages - support.microsoft.com < /a > 5, with the initial value to get average! ( using formulas ) < /a > Countif and calculate the percentage Discount, you can the. Table Count of Name and Count of Win next, divide that number by the average of those numbers. Into percentage, select the type of spreadsheet now we will see to! Profit margin percent can be combined to get the ration of decrease to! Following formula that the total value and the percentage though I know with certainty it should be %... Option with following formula price and the Actual units, you want the formula is still behind the scenes the... ) that you want to calculate percentages is that there isn & # x27 ; t a function calculate... However, I see 0 % though I know with certainty it should 0.2... % Diff 1/2 = 50 % the average percentage form number section of Home tab ) 15000... The relative values of the selected cells, then choose format cells.. It before using them in your PivotTable and open the PivotTable it will become SUM of Units2 label and! We multiply the result the USA how to find percentage in excel 2013 20000 - 15000 ) / 15000 two!