percentages

Hello, I have formula that automatically calculates the percentage of completion on a project between two dates (the start date and end date). The formula I chose to use is: =(DATEDIF(start date column, TODAY(),"d")+1)/(DATEDIF(start date column, end date column, "d")+1). This has worked well...

I am needing to set up conditional formatting rules of a column based on how it compares to another cell. I do not want to add another cell to calculate out percentages because there's already a ton of visible data in the spreadsheet. What I am needing to setup. Anyone have guidance on how to...

Hello I seem to have an issue getting accurate calculations when i use %. I'm trying to get a loan calculator but for some reason the "monthly payment" isn't the same as I have on my actual loan. It's always off by a small margin. For example i have 2 loans loan 1 = € 10.000 at 3,95% intrest...

I have a grid of cells with various numbers which all represent 100%. In another single cell I have ‘100%’ typed in as a percentage. The question I have is, what formula do I need to link the grid of numbers to the single cell so that when I type in ‘80%’ in the single all the numbers in the...

Hi Everyone, I’m trying to create a formula that uses both negative and positive percentages and doesn’t have any false statements. I would like it to be if cell G10 is >= -30% then G12 should display “partial response”, if G10 is <-30% then G12 should display “stable disease” or if G10 is >+20%...

Please help I am trying to calculate data and find the increased or decreased percentage between weeks: see below : <tbody> <tbody> A1 A2 A3 <tbody> Actions on Page (this wk) </tbody> Actions on Page (last wk) total action % 1 0 0.00% </tbody> </tbody> In A3 i currently have the...

I have this code below that I can not figure out why its given me a this error. lbSL are userform labels that display percentages. Please help. Thx Range("Z1") = WorksheetFunction.Max(100, CDbl(lbSL)) - CDbl(lbSL)

I have a workbook, where I have several sheets that links to items on sheet 1 Sheet1 contains values as well as percentages The values and percentages are displayed correctly on the linked sheets on My PC, but the percentages are displayed as values on the linked sheets when copied on to...

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 All I cannot reduce the decimal places in the below formula Can anyone help? <colgroup><col width="119" style="width: 89pt; mso-width-source: userset; mso-width-alt: 4352;"> <col width="107" style="width: 80pt; mso-width-source: userset; mso-width-alt: 3913;"> <col...

I have a file that on one tab has countif statements that yield percentages and on another tab I have linked certain cells, what I need help doing is I have 2 cells on tab 1 that I need to combine the percentages on tab2. Cells K3 and L3 currently 40% and 7% on tab 1 need to be combined on tab 2...

Hi Guys, I am trying to sum and average certain cells along rows but cannot work out the easiest way to do this. Example: Row A I have different percentages in row A which i want to sum total and average. To do this i need to sum only all the cells with the percentages in and average once...

Good Afternoon :) I know that Speedometers are not everyone's cup of tea, but I was after some assistance, please. I've searched this forum for an answer but nobody has asked the question, so here goes... I have managed to put a speedometer together but am stuck on negative and positive %...

I was given a data set with a Likert scale (rating 1-5). The data set has around 270 participants, and 8 questions (all with the rating of 1-5). The data has been coded (so it looks like it was taken straight out of Access- including the auto number feature on the far left). However, I need...

Hello, I have a range of percentages from -6% to 8% that each correspond to a dollar amount. I need to group these percentages into different buckets,about 8 or so. Once grouped, I want the buckets on the ends to hold less dollaramounts while the buckets in the middle will hold more. Is there...

I have a spreadsheet in Excel 2013 where I have a pie graph that displays percentages as the data labels. I had a custom format code, 0.0%;-0.0%; ,to hide zeros from the chart, however a request came through to display both percentages AND values. Now my custom format code is not working for the...

Hi, I'm trying to get my head around building this into our finances sheet and not sure where to start. What I want to do is have something like this https://www.calculators.org/budget/ - I want to specify a accounts with percentages and want to specify say a surplus of cash, and then divide...

I need some help calculating percentages. I have 30 rows, each row may hve a 1 or 0. I would like to calculate the percentage of 1's out of the 30 rows. I am essentially using this as an on time delivery. I get the 1 and 0 by comparing dates, if my start date is greater than my finish date...

Hello! Got a question on Excel line charts. Is it at all possible to create a simple line chart to show percentages, but replace the 'marker' with data points? For example, i have 40%, 50% and 60% in a line graph but instead of showing markers in various shapes, i want to show the actual...

I’m not sure if this is possible on a pivot table, but I’m hoping if someone knows they could help me out. I have net sales and cost of sales. The material margin is the difference between the two. In our business we like to see it as a percentage. I can either get the sum of the two and...