percentages

Hello I have a question regarding pivot table percentages I have PivotTables similar to the below QTY. % row1. 15. 15.00% row2. 10. 10.00% row3. 75. 75.00% The percentages are set as percentages of grand total, I would like to be able to add...

I can't believe you can't just add percentages with the usual =SUM(A1:A10) formula!!! The percentages I want to add are all created by formulas, not typed into the cell itself. The total percentage at the bottom of the page is adding up the individual weightings from a number of entries. How...

Hi folks, I have data with a number of dates and percentages and I'm trying to find the date where the sum of the various percentages passes a certain threshold. For a very simplified example, suppose my data looks like this: Row 1 (from A1:Z1) are month labels from 1 to 26. Row 2 (from A2...

Hello, i am new here. i am trying to find a formula to invert percentages. Example - if a payment is paying out 125% correct, i need it to reflect 75% correct. if it is paying 199% correct then i need a formula to read it as 1%. i hope someone can help! Thank you

I have an issue with a pivot table I am building for a client. The percentages of each row group are subtotaling causing the number to be wrong. In the image below you will see that the dollars are all summed that is fine. But the percentages are summing as well causing them to displaying really...

Hi all, this may be more of a math question than an Excel question, but I'm working in Excel so someone here might have the answer. Basically I'm trying to flip percentages. Eg. <tbody> A B C D E 1 10 30 70 90 200 [=SUM(A1:D1)] 2 0.4 0.3 0.2 0.1 1 [=SUM(A2:D2] </tbody> Here we can see...

Hi All, I'm trying to build a really simple form that calculates the monthly payment of an investment. so there are three textboxes: 1. Investment amount 2. Cost of capital 3. Amortization months. and then I have a button that calculates the monthly payment using a PMT function. The issue is...

good morning, i am trying to calculate percentages in excel, i am working on an annual report where the original report is generated for me with the proper percent. I have to remove numbers from the original and create a new percent, i am having trouble creating a new percent.i found that the...

Hi All, I have a column that shows percentages. The percentages will start at a high number, then slowly dwindle, and then at some point, the percentage will start to go back up. Is there any way to write a conditional format that will highlight the first percentage that increased from the...

I do standard monthly invoicing, and want to automate having to create a new tab and move a set of percentages from column I to F. Id like to copy tab called "PC 01" and create a new tab called "PC 02" as an exact duplicate of the tab. Then I want to move the percentages in I31:I43 and I48:I50...

Hi all I have a question about special cells. I am using Selection.SpecialCells(xlCellTypeConstants, 1).Select to copy / paste special - multiply to switch between GB£ and US$ in a large worksheet. The problem is, the code is altering dates and percentages that should stay erm, constant. Is...

I am new to VBA and am trying to create a For Loop for a designated range (Cells D2:O10). Each month, I have to remove the percentages in the current month and reallocate the existing percentages to retotal 100%. For example, if the percentages of row 2 totals 90% (Column C) after removing the...

I have a need for a line or bar graph based on percentages from an group of data. I want to have a baseline of 99.80% and show a list of names of around 12 people and where their percentages lie around that baseline. Their percentages are anywhere from a high of 99.99 and a low of 80.00%...

Hi, I wonder if someone would be able to help me. I have a spreadsheet that has columns as follows: 0 1 2 3 4 10% 15% 20% 5% 25% I want to then populate cells with the 3 largest percentages, however, if I use the LARGE function, it gives me the...

Hello guys Please help me with this question. 10000 10% 12500 15000 17500 20000 22500 25000 7% Above I want to distribute percentages incremental, to decrease between 10%-7%. There is one formula for this. Thanks

Ive got two columns, A has amounts and B has set percentages literally "40%", "35%", etc. which all are set exactly 5% apart. I need to see what is the average of all percentages as determined by the amounts in column A, meaning whatever actual is most popular, resulting in a number like say...

Sorry for the lousy title I have had a request from a different team to see if I could solve a problem for them....I cant. So I am turning to my friends here to see if you have an ideas. Basically we have a 13 week promotion table[Col A] That shows the consumer take up as a percentage [Col B]...

Hi everybody:) I have read many posts on this forum and it has helped me in the past, but this time it seems that I'm really stuck and need to post my actual question (classic story I guess..). Anyways - I have a dataset that lists shipment orders and various related information. I am trying...

I have a column which contains normal numbers, but also percentages. Is there a way to get the average only over the percentages in that column? so, a sumif function where the criterium can be a format?

Hello, I have a table with attributes from 1,2...8 and respective percentages. If you see, with higher attributes, the percentages are also increasing. For 6 and 7 I do not have percentages, but I have average of 6 and 7 that is 26,78%. I it possible to find the percentages of 6 and 7, if we...