percentages

Hi, I have a long list of %'s & I need to ensure each section individually adds up to 100%. Can a macro do this faster then me highlighting all of them? Below is a sample <COLGROUP><COL style="WIDTH: 48pt" width=64><TBODY> 18.94% 27.49% 10.81% 25.43% 0.87% 0.39% 7.47% 8.60%...

<TBODY> Plan</SPAN> POC</SPAN> Setup</SPAN> Reaff</SPAN> Jan</SPAN> 50.00%</SPAN> 10.00%</SPAN> 15.00%</SPAN> 10.00%</SPAN> Feb</SPAN> 40.00%</SPAN> 20.00%</SPAN> 20.00%</SPAN> 20.00%</SPAN> Mar</SPAN> 30.00%</SPAN> 30.00%</SPAN> 25.00%</SPAN> 30.00%</SPAN> Apr</SPAN>...

Hi Please can someone help me. I need some help in trying to figure out a formula to work out the below problem. I have a list of drivers from a race listed in column a, 1 thru to 22. In column b, i have their average finishing position from 6 previous races. What I need to work out is the...

Hello all, I am having some problems trying to write the correct formula in conditional formatting. I would like to be able to get a result of a value that is greater or less than 15% For example cells A1 A2 and A3 all have a value of 100. cell B1 has a value of 78, B2 has a value of 109 and B3...

Someone has told me that you are able to add the remainder of a percent by double clicking a cell but that someone forgot how to do so. For example, say you have a column with the following numbers 30% 20% 10% 0% 10% You want the 5 boxes to add up to 100%. I heard that there is a trick, where...

Hi there, How do I make a formula that is directly affected by something else in the formula. IE, I want to add 2% onto a figure, but then add another 2% onto the total of the first sum. For example (1000*1.02)the total of this sum*1.02 Thanks

hi, i'm fairly new to excel and am making a userform spreadsheet system. Basically, i was working out percentages for the system and realised that the formula that has been entered does display the percentage in the userform but not the exact sheet cell. This is a problem as the sheet cell is...

Hello! I have searched for an answer, but as yet am unable to find one. Here is my query: I have a formula which calculates the year-end total for tax and national insurance (class 4) contributions on my spreadsheet. However, I would like to do this month by month, bearing in mind you have to...

My questions is I need to subtract 3.75% out of a Price. example Column A I have 163.47 and in Column B I want my answer after 3.75% is backed out by Mulitpling Column A by .9625 The Problem I have is that when I get my answer in this case in get 157.33 but when you take that answer 157.33...

I would imagine this has been asked many times before as it seems like a somewhat common thing to need to do, but I'll be ****ed if I can find it. So I have a list of items... could be any number but let's say it's 20 cels for now. I want to randomly assign a percentage to each, such that the...

So, I have three fields: Revenue Under Goal (currency) Site (text) Order Line (number) My goal is to answer this question: By site, what percentage of the order lines have revenue under goal? So the ideal results would looks something like this: SiteA 20% SiteB 43% I admit that I'm...

Help....I have a column that is the sum of 2 other columns. I need it to list as a percentage, but without the percentage symbol. I used the formula of dividing one cell against the other than times it by 100. [ie. (A1/A2)*100], which works. However when the value is 0 (ie. 10/10) then I get...

I need a formula to work out a percentage increase from one cell to another for example. Cell A1 = 10 Cell A3 = 15 Cell A4 = 50% Thanks in Advance! :)

If i have A1 and i want to minus 30% off what would be the formula? Can anybody help please?

I have a very large table of numbers. The first 2 columns are a sequence of 2 numbers and the 3 column is the number of times that that particular sequence happened in the original data. Below shows a very small part of the data. I have shaded the cells beginning with 66 as an example. It is...

Hi i need to work out a given percentage of a cell. For example: 100 10% of £100 = £10(display in cell) any formula ideas?

<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p> </o:p> It's possible that I am simply blanking on this assignment. <o:p></o:p> <o:p></o:p> I have a two data lists - one shows the percentage of pre-tax benefits to commuting for 2011 Q1 and the other shows...

This is my first time posting here and am very new to excel, but feel as for the most part have a good grasp on the basics that I need for work. I am creating a monthly ledger for my restaurant. What I am needing is this. I am taking my total sales against my COG's for a total percentage of...

I am feeling very very rusty today. I cannot for the life of me figure out how to count the number of percentages that I have when figuring the percentages between two columns. I have two columns that come from a SQL table (A is the denominator, B is the numerator) and they equate to X...

I have have what I believe is a pretty simple question relating to investment returns I have a set of annual return percentages that I need some information out of and I am having a mental blank on how to do it. Basically I need to take the returns from each year and see what my ending value...