10%

Hello, Hopefully somebody can help me, I am trying to creating a sumifS formula or something I am looking to sum Qtys by date and item number from one sheet and match up to the item on a separate sheet: Sheet1 looks the following: A | B| C | D |...

I am looking for a formula for the following: List of names and salaries for the top 10% of a compinies top earners List of names and salaries for the bottom 10% of a compinies top earners

Dear professionals, when a cell result in ANY positive value, example such as "10%", I would like the very same cell to display as "Underestimate 10%" on the other hand a cell result in ANY negative value, such as "-5%", i would like the very same cell to display as "Overestimate 5%" Please...

Hello everyone, I'm trying to calculate the impact three ever changing variables are having on our month on month performance. We have 10 buckets that are filled with applications and the scenario is: The total number of applications changes month on month The % of total applications that sit...

Hello, I am looking for advice with a mathematics formula. Say in Cells A1:A4 i have the below 4 percentage values: A1 - 45% A2 - 25% A3 - 20% A4 - 10% Total - 100% I am looking to set up a formula in cells B1:B4 that if i change one of those % values in A1:A4 that the changed value be...

I am trying to use a formula to calculate 10% time improvements on my student's mile run times. I came up with a workaround to split the minutes and seconds into different cells, convert them into total seconds, multiply by .90, then divide by sixty to get Min.Sec. Not fully working though as I...

hi all.. how to make custom number format like this <tbody> entry-input expected result - display 2% Tax Ratio (2%) 10% Tax Ratio (10%) </tbody> any help, thank in advance.. .sst

I am having problem understanding the logic of the top 10% rules in conditional formatting. What does this mean? https://www.youtube.com/watch?v=T64RLaLngbc

Hi Hoping someone here can help me... I have a SS which has an income cell and then an expenses cell... In a new cell which looks at the expenses and shows what percentage of the income is now covered by expenses and gives the percentage figure and then like a traffic lights system, green from...

Good morning, everyone. I have a static cell ($A$6) on worksheet that is the goal for the number of tickets that should worked on during the week. Starting at cell (C11), I have a range labeled "rg" that is Dynamic and could span many columns depending on how many teams submitted tickets...

Hi, I am looking for two different formulas which will calculate score in B & C column respectively, logic given in below table … Please help me build the formula … Formula 1. >1.25 = 0 Increase on each step 0.132% Max 10% at 2 Formula 2. <0.21% = 0 Increase on each step 0.25% Max 5% at...

I have a table that has two columns of ranges I would like to INDEX and MATCH. EXAMPLE: I need to index and match 48.95% (in cell I4) using the table where Column O is 45% and column P is 50% with the probability column at $R$4:$R$43. How do I INDEX and MATCH a percentage like that to fall...

Hi, i am trying to use a sumif formula to identify where a customer name (column A) is a duplicate and the value in column AY is + or - 10% of the value in the duplicate line. Is this possible using a sumif? If not would anyone be able to suggest a different solution? Many thanks,

Can someone explain how to write a IF formula in excel? If cell 10% of B9 is greater than 35, display the value, otherwise display 35.

Hi Is there a formula to round up a number to the nearest 10 cents? So if the number 0.78 was in cell A2, and it was increased by 10% in B2 to 85.8, it would be rounded up to 90 cents.... <colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody> Number 10% 0.78...

I have a future value of 2307936 (after 5 years) and need to make an investment every month, with an annual increase of 10%. The rate of return on investment is 9% per annum. If there is no annual increase of 10% I am getting 30882 as PMT. How do I calculate with 10% annual increase.

Hello I have been asked to create a bubble chart but I need to have each bubble dislaying 2 pie pieces (for example one bubble that has a "pie piece" to represent 10% of the bubble. Does anyone know if this is possible? Thank you for your help

My brain's gone blank for some reason. Say I have $100 in cell A1. And then I have -10% in cells A2, A3, A4, and A5. I want to know what happens if I take 10% off the $100 ($90)...and 10% off of that ($81), and so forth so I end up with $65.61 after taking four 10%s off. I can keep a running...

My brain's gone blank for some reason. Say I have $100 in cell A1. And then I have -10% in cells A2, A3, A4, and A5. I want to know what happens if I take 10% off the $100 ($90)...and 10% off of that ($81), and so forth so I end up with $65.61 after taking four 10%s off. I can keep a running...

Question, I have not used this and I need to set up based on 2 criteria I have a column with names in it and a second column with codes in them. I only want 10% of the total codes for each name Name 1 can have 20 codes so I need to randomize the two codes that get audited. Name 2 50 codes so...