percenetage

Hello. First time posting :) I am putting together a Gantt chart and wanted to create a formula to give me the total percentage of the task completed, based on the sub tasks being completed. Please see attachment. Hopefully that makes sense

Hi, I am sure this may be availabe in simple math but I need a formula for it. Say I have a range of numebrs where 1 is the lowest and 73 is the highest, with all other numebrs in the range. How to i streth this both ways so that 1 becomes 0% and 73 becomes 100%? Which means 37 may be in and...

Formula to look at current percent in a cell and calculate the percentage needed to reach target percentage. For example: goal percent is 15%, current number is 12%. Need to calculate what percentage would be needed to bring the 12% up to 15%

<tbody> 2 10% 3 5% 5 35% 7 27% 9 23% </tbody> I have these two columns in Excel file. The first one with grades, the second with percent how many students get that grade. How to calculate average grade from this data?

Hello, Apologies if this is repeated, I've tried searching for an answer but have not found anything. I am looking for a way to calculate a percentage based on the number of cells with a value example <tbody> Sales person 1 Sales person 2 Sales person 3 Sales person 1 % Sales person 2 %...

Hi, I have values: <tbody> Values (col a) Percent (col b) Result (col c) 20 2 20.4 30 5 31.5 10 40 10.4 </tbody> equation should looks: result = 20 * 1.02 = 20.4 result = 30 * 1.05 = 31,5 result = 10 * 1.4 = 14 How can I do it into Vba? Because I doing now as below: (result is the...

Hello, I needed some help with a few formula's. Here is my data. Per Advertiser ID, I need to find <colgroup><col></colgroup><tbody> Total requests sent with user data Percent requests sent with user data Bid volume Bid rate Avg bid value (multiply your answer by 1000 to get...

Hello I have some experience in excel but not much. My boss at works wants me to make an excel worksheet that we can send out to our clients to determine the amount they will owe us on any job that comes up. Pending on the job amount the client their amount will vary. For example if they were to...

I am looking for help with a formula that subtracts 3.4% from a total. The total amount is in cell K (£33.50) and I want the formula to subtract 3.4% from this total and appear in cell O. Really appreciate your help Thanks