25%

I have a concatenate formula to output into a cell something like "100% / 75% / (25%)" (code is below). I'd like to either bold or italicize that 25%...something to show that the (25%) is a variance and not a raw value. It needs to be something other that "red" font since sometimes the...

Hello, i would like to know what equation to use if i want to use the below condition if the result is 0% or in negative % then score is 0% and if result between 1% to 25% then score is 25% and so on till i reach score 76% till 100% then score is 100%

I have a userform with two textboxes that receive a number from a spreadsheet when double clicked. The numbers on the spreadsheet are percentages so I've formatted the textboxes to show the percentage. The code below works fine. I would now like to add those two textboxes together in another...

hello i have a range of data in column A, A2:A159, i am trying to find out the average for the top 10%, top 25% middle 50% and bottom 25%. is there a formula i can use for this, example below <tbody> Column A Column B % Growth Start Balance 32.78% $100,700 16.52% $122,245 </tbody>

This table has some data from an analysis of the game of tennis. Row 4 shows the names assigned to each column. Columns D & E are assigned the names PGS_A & PGS_B, which stands for the probability of Player A/B returning a groundstroke. Column F (NumTrials) shows the number of trials...

<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Calibri; color: #000000}</style>I'm trying to calculate the cumulative total up to a certain maximum. In the example below, I need column D to calculate the contribution amount (by multiplying Column B and Column C), but...

Please could someone give me an idea if this is possible? If one of the cells in a table column is greater than 25% I want excel to send me an email. so something along the lines of: If (cell in net % column) > 25% then (send me an email) Although its not essential, it would make sense to...

Hi, In a table, with 500 rows and 20 columns, of documents that cost 200,000 dollars. How do I extract 25% of these costs to physically check the documents (sort of sampling but random). Thank you.

Good morning, My goal is to sum cells in column 2018 only when there are non blank adjacent cells in in column 2019. Can you think of a formula to do that? Do I need to create a new formula in VBA? Thank you in advance. <tbody> Day 2019 2018 % Chg Mon 50 40 25% Tue 50 40 25% Wed 50 40...

Hi can you say what I did wrong here I want to say if the value in bi is greater than 1384.116 then take bi and minus it from 1384.116 then that result must be multiplied by 70% of the value in c1 then multiply that value by 25% thanks tks Abidh (IFB1>1384.116, then(b1-1384.116)-(.7*c1)*.25)

I have a cell with the value 125% in it, however I need to make the cell display the words "INCREASE BY 25%". Example: If cell A1 = 100, from a pull down menu in cell A2, I want the user to be able to select "INCREASE BY 25%". Having selected "INCREASE BY 25%", the value of cell A1 then needs...

Hi everyone, I'm working on a depreciation spreadsheet, and Im usually really good at formulas, but I just cant get this one to work. Some reason I cant paste pictures, so Im going to write out my excel layout, hope it makes sense, the formula goes in Column I The formula applies to Row 10...

HI I am working on a project status report if a date field is populated then calulate a % in a differnet cell. I have 4 steps in the process each 25% to complete if excel date field populated then add 20% to complted project <tbody> a b c d e f 1 % Completed 25% 25% 25% 25% % Complete 2...

Hi all, I have a macro that reads through a bunch of data and identifies unique names based on certain criteria. Once this is completed, I have a message pop up that tells the user the total number of unique names and another message pops up identifying 25% of that total. We need to identify...

Hello, I would LOVE some help with this one if anyone can please...I would be most grateful! So... I have a product and it has two costs: the cost of the physical goods themselves and then the cost of advertising, which is a cost-per-acquisition, or CPA. I also know that I want to make a 25%...

Hi All, I’m trying to create a replenishment tool, and I want to come as close to shipping master cases as possible. Current replenishment = 190 Master Case = 105 I am trying to create a formula that looks at the current replenishment (190), and if it is within 25% of however many master...

Hello Guys ! Is there any formula to do automate this calculation ? <tbody> A B C D 1 10% Discount 3 ( Insert Formula ) 30 2 20% Discount 10 30 3 15% Discount 50 333 4 VIP 7% 10 143 5 Weekend 25% 25 100 6 Weekend 25% 25 100 7 Weekend 25% 25 100 8 15% Discount 10 67...

Hi everyone Hoping someone can help... I have 2 tables on different sheets like so: Sheet 1 <tbody> A B C D E F G 1 Jan Feb Mar Apr May Jun 2 Apples 10% Off 25% Off 20% Off 20% Off 10% Off 20% Off 3 Oranges 20% Off 25% Off 10% Off 20% Off 10% Off 20% Off 4 Bananas 25% Off 20% Off...

Hi, I need assistances please... I have cell with % in column "T", and I have about 400 lines in it that I would like to add vba code that when any cells in column "T" is above 25% to start flashing, red and black color and not to stop until I close sheet. Can anyone please assist me with this...

Hello all, I'm looking to create a formula that will decrease a percentage applied each year by a 2.5%. For example, to start or year 0, 50% is applied. In Year 1 this is reduced 2.5% to 47.5%, in year 2 there is a further reduction of 2.5% to 45%. This continues until the percentage applied...