50%

This is fairly difficult to explain. I want a spreadsheet to calculate 50% of the total and then calculate 25% of that 50%. This should be output as the total amount discounted and then as the total payable in another cell. For example, the total is £2500.00. 50% reduction is £1250.00. 25% of...

I would really appreciate help with the following formula as I just can't get it to work. For each failure during a month I get charged 10 If I fail three months in a row I get charged and extra 50%, so 15 per failure. If I fail again in the next month I get an additional 50% on top, so it's...

I been searching for a while to determine how many records in a data set. This is so I can determine how long it will take to import. I would like to use this information in a progress bar. I have the progress bar going, I just need to plug values in the code to have the bar move. I can make...

Hello, I am trying to get a Max IF formula to work. At first I thought of using an index match with Max however I read online that the below formula would be a better fit: =MAX(IF(('% Complete'!A1:A6=A1),'% Complete'!$B$1:$B$7)) I need the formula to return the Maximum percentage from the...

Hi there, I have a calculation taking place on a work sheet - a calculation to work out a percentage. =IFERROR(SUM(D6/D5),0) In this example I'm using Loan (£100,000) / Property Value (£200,000) = 0.5 (formatted to %) = 50% All I want to do it have my user form pull through the value of...

Hello Mr. Excel Community - I'm trying to forecast payment date/amount for some payment terms that are more complicated than the usual net 30. Does anyone have any recommendations here for some formulas that are dynamic? Here are some of the payment terms: <colgroup><col></colgroup><tbody> 35%...

I'm guessing this can be solved with a sumproduct but I really don't know for sure. <tbody> 0-5KM 50% $5 5-10KM 15% $10 10-15KM 15% $15 15-20KM 10% $20 20-30KM 5% $25 30-40KM 5% $25 </tbody> Here's a table which shows how much we charge (col C) for various distances. Col B shows...

Hi All, I am working on dashboard in which target based scores are being given. e.g Min & Max target for Calling - Minimum 60 call and Max >=70 calls per day Minimum score 0 and Maximum is 20%, Score will be proportionate where Achievement 61= Score will be 2% , Achv 62= Score 4% and so on...

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

<tbody> A B C D E F G H I 1 2 2662 50% a d 3 1331 20% b f 4 5 a b c d e f g h 6 2662 50% 0% 0% 50% 0% 0% 0% 0% 7 1331 0% 20% 0% 0% 0% 20% 0% 0% 8 9 </tbody> Hi everyone May I know what array formula should I type in Cell D2 in...

Hello, I need some help! I have the formula below but would like to modify it to include a different cell somehow. It should reference another cell saying not to go below a certain value. The current formula does take B4 up or down 50% depending on the value but the problem lies when it goes...

Hi All, Thanks for opening this up. I have an export of survey findings like this. <tbody> A B C D E Average Group A Group B Group C Yes 50% 65% 46% 46% No 50% 35% 54% 54% </tbody> I would like to format this in a way that columns C-E are highlighting significant differences of more...

I've been using the formula for quite some time now with much success but this one got me stumped doing this project. 50% of the columns gets extracted correctly but the other I get "#REF!". The data source is from the same table, using the same headers. Any guesses why?

Ive been lurking on these boards since I started working and a former boss of mine steered me to the site. you don't know it but many of you have been incredibly helpful over the last 6+ years, so thank you. boss of mine decided to start a new monthly excel challenge and while I have one way of...

How do I Cap if i want lets say -50% the minimum and +50% the max?.

Hello everyone, Quick question here - I downloaded one of Microsoft's sample project plan templates. As I started tweaking it, I noticed underlying logic seemed to stop working. The cells have a progress bar, so whatever percentage amount you put in the bar in the cell adjust to show.... so...

Hi, I have percentage values in certain cells on a sheet (E3 currently displays 84% for example). I would like a shape which takes the value of E3, and then applies that percentage to a gradient fill level of the shape, starting at the bottom. So if the shape (an Oval), was to take 50%, then...

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

<tbody> Questions 2016 Favorability Standard Deviation 2017 Favorability Standard Deviation 2018 Favorability Standard Deviation Result Q1 66.5% 1.15...

Hi, I'd greatly appreciate help finding a formula that will calculate the figures in red (cells C3:F6) in my mockup below. Column I contains sales thresholds at which different bonuses are paid in 4 tiers labelled in Column H. If I sell 100 units in Quarter 1 (Cell B3), that would mean all of...