10%

Hi all, I am working on resizing an image in Photoshop rather drastically, and one of the tips to to go in 10% increments until I reach my goal, and since I am looking at roughly 100 steps, I was thinking that I could calculate my numbers in Excel. I'm just not sure how to do that. I am starting...

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

4 years ago with the help of these forums, we managed to get a formula for us which we've been using ever since in our profit calculation sheet for e-commerce. It was this thread here...

Hi, I'm trying to figure out why XIRR and IRR are showing different returns in this case (simple bond math). These are the cash flows: 4/30/2018: -1,000 5/1/2018: 100 5/1/2019: 100 5/1/2020: 100 5/1/2021: 100 5/1/2022: 100+1,000 IRR returns 10%, which makes sense. XIRR returns 13%. Could...

Hi there I need to return different results depending on the value of a cell. Example: In cell B1 and C1 there are standard numerical data. In cell E1 there is a simple formula: =C1/B1 (with the returned value shown as %) In cell F1 I need to return: If D1="yes" then add 5% to the total of...

Hi, I have two sets of table, one with few rows and its corresponding percentages (This table varies time to time i.e. number of rows, percentage etc), The other table has fixed 11 rows with percentage values. Illustration below: Table1 (Dynamic) 500,000 - 10% 1,000,000 - 15% 2,000,000 -...

Hi all. I have a fairly complicated question and I've been racking my brain for a while. I have the following data set: <style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style> <colgroup><col style="width: 146px"><col width="79"><col width="83"><col...

Hi, I run a subscription club to a club. We are putting in place new pricing, as there is a huge amount of historical prices in there that we need to get back in line. In summary, the new prices will be £40 per month. Some pay this already, so will hold that rate.. so pay a lot less... as low...

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

I want to know the formula for the following example; I want to be able to select the following in the range of M2 through M30 <tbody> 100%: 90%: 80%: 70%: 60%: 50%: 40%: 30% 20% 10%: 10%: 0% </tbody> If i select any of the %'s from MY COLUMN M above, I want the...

I am trying to create a macro that inserts a specific formula into a cell and auto fills to the last row. It then is supposed to sort a range of a few columns and repeat on each worksheet in my workbook. I had this macro working until I added the last row verbiage. I am now receiving a...

I am wanting to compare a new store to existing store performance. Any stores that meet the criteria such as same location, sales within 5%, GP within 10% and size within 10%. The below formula loads in all store names not just the ones that meet the criteria can someone tell me what I have...

Sorry folks, not the greatest thread title I know but I thought best to put all three questions in one post. 1) I currently have a field (R17) that is automatically 10% of R15. However I want this figure to go no higher than 200. (Eg - R15 is 10,000, R17 is 200 rather than 100). 2) I also want...

I'll try to keep it simple: I have people doing work for me. Clients pay them directly and then they pay me a fee. They pay 20% on the first 10 clients 10% on clients 11-20 Then 5% on any over 20 How do I get excel to calculate this for me. I obviously need to calculate how many clients...

Thanks to shg, I'm now able to estimate how much time a sub has left before it's complete. However, when I put this function within a loop, I'd like to test if the % complete (dPctComp) is a multiple of 10% (so that the function doesn't produce an output with every loop, only at each 10%...

Hi There, I'm trying to do the following: if K7 is greater than or equal to 10 but less than 11 enter "10%" if K7 if greater than or equal to 6 but less than 10 enter "7%" If K7 is greater than or equal to 3 but less than 6, enter "5%" If K7 is less than or equal to 2 enter "2.5%"...

Happy New Year to everyone! I have a question that is centered around a policy-change, whereby, a worksheet that had a discount that used to apply to all items in a column (general discount, and therefore, quite easy to write) that now excludes items that are "services based". I have all...

I'm trying to make a commission structure for Excel and it's pretty difficult So we get paid 30% of the front gross + 10% of the back gross = total commission. Example: $2,000 front = $600, and $2000 back =$200 grand total $800 if the front is negative, subtract that to the back gross x...

Friends, I am a novice excel user and I need your help as I am also a novice algebra student as well. I am developing a decision analysis worksheet for a bid proposal. The client states that they anticipate issuing $6,700,000.00 in service orders over the life of the contract. The $6.7M...

I'm trying to add a commission structure. front and back gross. back gross is paid 10% if the front gross is negative, the you subtract that from the back gross, then multiply x 10% if the front gross is positive then no deduction needed. <style type="text/css"><!--td {border: 1px solid...