80%

Hello! I’m working on reporting to show the overall impact an agent has on our site. Our site KPI goal is 90%; Agent 1 has 20 surveys averaging 80% Agent 2 has 100 surveys at 80%. Both are obviously not meeting but Agent 2 has a bigger “drag” to our site. Can someone help me with the formula...

hi, in excel I have <tbody> Sex Probability Cumulative Prob M 80% 80% F 20% 100% </tbody> These are in a sheet called probability of Client and run from cells E1 to G3. In another worksheet i have put the below formula in. Most of the time the result is #n/a with the occasional 'M'...

I need to calculate some weighted percentages with the following criteria: If X=70% then I multiply 80% of 30% If X=75% then I multiply 100% of 30% If X=80% then I add 10% to the 30% Anything beyond 80% is at most 40%. How do I calculate what this percentage will be if say for example, X =...

Hi all, I want excel to return me the value of 1, when the percentage score is higher than 90%, value of 2, when the the percentage score is between 80% and 90%, and so on. Would appreciate your help. <tbody> </tbody> <tbody> 90% 1 80% 2 70% 3 60% 4 50% 5 40% 6 30% 7 20% 8...

Hello, I have been getting help from your forum for quite a while, but I've always found the answer. This is the first time I needed to ask one. I have a spread sheet where I am trying to show the average percentage over a few cells. I'm trying to make R10 average out R5:R9, but to ignore -80%...

please !, separate last digit, create a field to type the strings then confront with which lottery hit 80% or more ojetivo = play the same string in several lotteries

So I need to keep track of staff member's attendance, since we have a goal of 80% to meet for calendar year 2018. I have several workbooks, one for each staff member, since I have other goals I have to track. As a group, I want toadd up all their monthly attendance, for example: Attendance...

I have a table where I have the cost of each item in column AC (AC5:AC60). In the next column I have percentages (each rows percentage of the total value or the sum of column AC) I want to do a SumIf. My condition is if the % value in column AD is less than or equal to 80%. I keep getting...

I've got two lists of names on two tabs. One is from payroll and one is from the email system we use. People have left but their email accounts have not been deleted. I want to run a check and flag all the names that have email addresses but are not on the payroll so they can be removed...

I have a total cell ($.024046) that sums all rows above which contain 1 blank cell (XXXX). On the side is a cell which equals 80% of the total cell ($0.19). How can I make the blank cell match the cell returning 80% of the total. With trial and error, $.32 in the blank cell will output $.32 as...

Hi Can any one help me on this? i have below data which need to compare with the next row and give green color if 80% text matches image removed i have written below code but excel is getting hang whenever i run the Macro sub colorr() Set shgroup = ThisWorkbook.Worksheets("Grouping...

Hello, I need some help creating VBA code where the cell color changes to yellow if an individual’s total for that particular month is over 100%. Here is a sample of my data: <colgroup><col><col span="2"><col><col span="12"></colgroup><tbody> Name Title Plan Notes Mar Apr May Jun Jul Aug Sep...

Hello, in want to use a formula that gives me, in percentage, the value of another cell. For exemple if cell a1 is "2", then it will return the value within the logic 0 is 100% and 5 is 80% could someone help please? thanks

Here's a quick example...sorry for the formatting...but I don't have the tools to post html sheets...if someone could point me to what is being used these days i'll add it but essentially i'm trying to figure out if Running Value is top 80% of all values based upon the multiple criteria i...

Hi all, I am facing some issue while setting up formula for target based incentive. Problem set has 3 classes: Below 80% achievement - payout is 0% at 92.5% achievement - payout is 100% Between 80% to 92.5% - payout is proportion (basically the gap between 80% and 92.5% represents 100%) At...

I have two columns of data, A and B What I do is find the max number in column B, report that value in C3. Easy enough with =MAX(b2:b5000). What I need to do next is find what 80% of that value is then search “B” for a number equal to or just above that 80% value. Then reference the...