100%

Hello Ladies and Gentlemen, Please refer to the below table: <tbody> A B C D E F G Table 1 Table 2 Amount % of Total Portfolio % of Total Asset Under/ Over % Notes 2 >=20% 100% 15,292 4.7% 1.5% -15.3% I can't understand how this formula works. The value isn't true but still...

Hi, Any ideas how to get around this problem … I have 2 lists ofnames. One list is First Name and Last Name, the other list is Title First NameLast Name. I want to identify who is on both lists as best I can. Any ideas how to do this in excel? I appreciate there maynot be a 100% accurate...

Hi All, Hoping you can help. I am looking to work out blended % formula amount in a row of cells against another 2Rows already populated with % amounts Eg A1 through M1 totals 100% B1 through M1 totals 100% Require blended formula in cells C1:M1 that would also total 100% Thanks!

Hi All, Hoping you can help. I am looking to work out blended % formula amount in a row of cells against another 2Rows already populated with % amounts Eg A1 through M1 totals 100% B1 through M1 totals 100% Require blended formula in cells C1:M1 that would also total 100% Thanks!

Hello, I am struggling to do conditional formatting for a row. It has several percentages from 0% to infinity. I want everything below 100% to be red and everything 100% or above to be green. There are some cells with dashes when the percentage is not available. Any idea please?

Hi, For a few days now i have been having problems whilst making forms etc. Some good members here has advised the code or edit to use but when i copy from her & paste into my sheet i see errors etc. The member who put the advice here did not see any errors at all & as such worked 100% for...

Hi, I have a formula that is basically looking at another cell and returning the % number from that cell: =INDEX('Yield from PPM-2001'!$C$4:$L$40,MATCH($A14,'Yield from PPM-2001'!$A$4:$A$38,0),MATCH(E$3,'Yield from PPM-2001'!$C$3:$L$3,0)) If the cell it looks at has a yield of 0% then it...

I'm thinking that this may not be possible having scoured the related threads I can find on here... I have a set of data which I want to show as 100% stacked and an additional one I want to overlay on a second y-axis as a line (scatter... whatever). Is there a way to do this? I am plotting...

Wondering if you could tell me something about this formulabeing used. I understand what the formula is doing and how it worksbut what I don’t know is “why”? Why are they using-1? What does that even mean? When you usethe -1 you get a total different result so I’m trying to understand...

I'm trying to reverse engineer hours based on a team with various %s totaling 100%. In the end, hours X each individuals known Rate will all sum to be $175,000. I have a program that does this but I'm trying to replicate in excel. First table below is completed in the program and every time I...

Greetings, I have a bar graph with the y-axes expressed in percent. The minimum percent value is always 0%. However, the maximum percent value can exceed 100%. Sometimes, depending on the data, if I set the y-axes maximum scale for Auto, the chart may have a scale that is less than 100%. I...

<tbody> A B C 0 1874.35 100% 1874.35 0 -100% 0 0 0% (not #DIV/0!) 5672.66 561.77 -11% </tbody> Hello, I am trying to figure out a nested formula to calculate difference in percentage between two values and to not show #DIV/0!. Please help. Thank you!

Hi everyone! Anyone know what kind of formula I could use to work out a score between tiers of achievement? I.e. if 100% Payout Target = $50,000 the breakdown is as follows: 0% Achievement (A) Score = 0% Payout 35% A Score = 25% Payout 100% A Score = 100% Payout 140% A Score = 225% Payout...

Hey guys questions on percentage formula between two dates so I have: Tested two formulas: 1) IFERROR(IF(TODAY()>=X6,””,MAX((TODAY()-W6)/MAX(X6-W6,1),0)),””) X6 beingend date W6 being start date Issue with this is i don’t receive any “100%” if the date is already completed 2)...

I am having an issue and was hoping someone can help me. I'm new to excel so I basically just searched old threads to come up with this formula; but ts not working 100%. Maybe this is just wrong for my needs but it seems to be working in some cases, just not all...

So, I am trying to determine how best to calculate Tie rates for a commission structure when I know what the total payout should be at 100% achieved? Here is a sample of the tier structures, <colgroup><col><col><col></colgroup><tbody> 0.00% 75.000% 2.00% 75.00% 90.000% 3.00% 90.00%...

Hi I have a pivot chart that's based on data that only goes up to 100% The data has categories with price compliance figures of 43%, 75%, 94%, 100%, etc. However, although the maximum price compliance figure is 100%, the vertical axis on the Pivot Chart goes up to 120%!! Do you know how I...

Hi I've got a Pivot Chart which shows certain metrics for different categories in percentage terms. None of the percentage values exceed 100%, but the chart goes up to 120%! Is there a way I can reduce plot area so it only goes up to 100%? Thanks

Hi I need some help calculating a weighted sum. I have an example which shows how it should be done. Any help is great appreciated! Thanks in advance Sample Data: <tbody> A B C D E F G Total B 48% 5% 33% 14% 100% C 16% 2% 5% 9% 21% 23% 23% 100% F 13% 35% 30% 22% 100%...

Hi all, New to the forum and couldn't find anything on this one. I have the following basic average formula that I need to add some sort of IF to. =AVERAGE(I3,I8,I13,I21,I27) Goal is to take the above and only include cells that = 100% in cells E8, E13, E21, E27. Basically, I only want...