percentage

Hello - I need help determining a formula that will calculate percentage of achievement based on the month were in. I have a target and actual amount. I can get the percentage of achievement based on that but is there a way to favor in the month of the year in the calculation Thanks!

Hi, this is my first time post and I need help with a formula to calculate the average percentage for each cell including the previous cell. For example, cell I2(Apr-18) contains a percentage, I would like to add that percentage to cell J2(May-18) and find the average, and for cell K2(Jun-18), I...

I am trying to find the cell in a row that is >= 0% <tbody> Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec -0.3% -0.2% -0.1% 0.1 0.2 0.3 0.4 0.2 0.5 0.1 0.15 0.1 </tbody> In the table above i need to return Apr as the first month where the percentage is >= 0

Hello, I am brand new to excel and need some assistance on how to enter a formula that will calculate the percentage of how many days a week an employee clocked in at 10:05am and anytime before that. <tbody> May 05/01/19 10:06 05/02/19 10:05 05/03/19 10:11 </tbody> <tbody>...

Hello Can somebody help me with this problem i'm having with, im trying to figure out how to determine Time1 is (Time2 - #%), this is an example of the problem : im trying to get a broader percentage like 15%,16%,17% etc to 30%. tried using a simple formula but the result is off by a...

Hi All, I have total units of 787 (J3) & errors of 5 (N3), cell formatted to % . Formula I Cell O3 : = N3/J3 , answer in my opinion should be around 98% , why is my formula displaying 1 % ??? Sorry if this sounds daft … but its driving me mad ! Many thanks, Russ

I have a spreadsheet that presents the results from a test.The number of columns depends on the number of questions and the number of rowsdepends on the number of test takers. I need to look across row 4 and where ever the word “Score”appears I need to average the list of scores in the rows...

Hi guys, I have a spreadsheet with multiple customers and price they paid for different items. I am trying to find what percentage they spent on each items Can it be done with vlookup? Here is an example: <tbody> Name Item Price Percentage Breakdown John apple 2 Tom apple 3 Amy apple...

Hi there team. So I have a 1 issue that has got me... Please help I have code that allows me to add a few values and divide them by the number of times someone works in a full week. but what i want to do now is after i have allocated the number of days each person works i want to deduct a...

Hello friends! I am relatively new to Pivot Tables, and just learned of DAX yesterday to help me with some analysis I am doing. Now, I have not been able to find this answer for another DAX measure field, and hope that someone will help me with what seems to be an easy question. My source data...

Hi I have a graph that has product & product sales, the product sales have data labels with the numeric value on top, I'd like to add percentage variance underneath this but not sure how, I've seen a few threads that say you add the percentage variance data series, overlay it to 100%.. but then...

Hi Guys, A little bit of help. =(B2*C2+B3*C3+B4*C4)/SUM(B2:B4) This is my formula for getting the average percentage of average percentages but what is I have more than 3 rows that needs to average? Let's say 100 rows of average scores. How do I shorten my formula? Thanks! <tbody> SKILL...

Hi guys, i know there will be a simple solution to this. How do I get for example 90.7% to show as .907. Many thanks, Jim

I need two formulas that read the values in column D compareit to column G and H. Based on the outcome column I would say “100% Met” or “50%Met” or “Not Met”. First Formula Rules: To achieve "100 % Met" the values in column D haveto be greater than or equal to the values in columns G To...

I have a project that I'm working on and running into a problem. I am trying to calculate if a phone number starts with specific area codes. I want to count them and get a percentage of the total ones in a sheet that i can add to. I would like to eventually do conditional formatting for easy...

Hi there I have updated a table of percentage, but they are displayingincorrectly Example 95% comes out as 9500% as a percent there are no decimals? Can any body suggest a format that will convert my percentcorrect format i.e. 95% not 9500.00 I have a table of 100 of these figures? Thank you...

I am new to Pivot Tables and am having a problem with percentages. I have a Pivot table which looks like this Block Incidents Cumulative Incidents People Cumulative People Percentage Answer should be 1 47 47...

Was wondering if anyone could help me out with an Rating Percentage Index (RPI) tool. There used to be one at https://techgraphs.fangraphs.com/an-rpi-spreadsheet-for-you-yes-you/ but it seems it has been taken down. I am trying to calculate RPI for a sports project I am working on and the WP...

Hi Is it possible to use pivot table to show the cumulative row sum percentage (not % running total) ? sample is shown below <tbody> Count of Date Column Labels Row Labels Pass Failed Grand Total Jan 14 17 31 Feb 17 11 28 Mar 17 14 31 Apr 14 16 30 May 12...

Good Morning, I have this formula to give me the percentage completed by count of project =COUNTA(L5:L10)/COUNTA(B5:B10) but what i need is that if in L5:10 have the words "Completed to give me the percentage only when the words completed are in the cell and not to count any other words in the cell