# percentages

1. ### Percentage complete formula between two dates

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...
2. ### Conditional Formatting - Variance of Percentage compared to another cell

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...
3. ### % calculations doesn't seem accurate

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...
5. ### Using Negative Percentages in formulas

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%...
6. ### Calculating percentages - error

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...
7. ### Max function Type Mismatch

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)
8. ### Percent (%) displaying on linked sheet on one PC but not on another

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...
9. ### [H] Formula for getting the average percentage of average percentages

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...
10. ### Display Formula Result as Percentages

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...
12. ### A bit stuck

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...
13. ### Speedometer with -% and +%

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 %...
14. ### Likert Scale to Percentages of Particpants

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...
15. ### T-Shirt Sizing of Data Set

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...
16. ### Format Code for Data Labels to hide zeros when both Value and Percentage are selected as Label Options

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...
17. ### Budget calculator for Excel?

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...
18. ### Calculatinng Percentages

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...
19. ### Line graphs with data point as markers

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...
20. ### Sum of % in Pivot Table

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...

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back