15%

I have a formula that I want to write as follows: <tbody> <tbody> A B C D E F Region Country Charge Rate Card 15% Margin New %margin new rate formula for cells in column F C&W Europe Austria € 750.00 € 637.50 23.39% € 637.50 IF E2 is less than 15% then increase D2 by the difference in...

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, I am trying to calculate the minimum and maximum amount the value of a cell based on another cell and cannot figure it out. I have never used this function. Helpful (hopefully) example. the max allowable increase is 10% but the below increase is 15%, so I would want the result to max...

Hi There, Please help! i have a table set out as follows, <colgroup><col><col><col><col><col><col></colgroup><tbody> A B C D E 1 Age of Debt Business Person Govt Other 2 Current 0% 0% 5% 0% 3 Up to 30 days overdue 10% 5% 5% 0% 4 31 - 60 days overdue 20% 5% 20% 0% 5 61 - 90 days...

Good morning I am creating a spreadsheet that needs the following and I'm having trouble creating this formula. I earn commission and I am charged a specific percentage of my sales until I reach a specific sales volume number , say 15% and charged a different percentage once I reach another...

I need to show certain percentages if certain numbers come up. The formula can be in A1 and the number can be in B1. Example: If B1 is equal to 2.9 or less put in a 0 if B1 is equal to 3 but less than 3.5 put 10% if B1 is equal to 3.5 but less than 4.0 put 15% if B1 is equal to 4 but less than...

I have the following formula - =(January!E3+February!E3+March!E3)/3. How woud I add a cap of 15%

I have a worksheet that has column A (state) and column B (individual ID #). I need to review 100% of AZ, FL, IA, TX. But only a random 15% for every other state (i.e. 15% of HI, 15% of NY, 15% of TN, not an overall 15% if the remaining states). Can someone help me to write a formula for this?

So i'm at work and we have a spreadsheet where every price in cell A is 15% off. we did the right formula in the box (=A1*.85) everything was looking good so we saved it. when i went to open it this morning it hasn't saved the formula the prices are not 15% off. I tired entering the formula...

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 all, Hoping to get some help with this problem.. What I need is a formula for column N which automatically calculates how many of the %numbers in column N (2:22) are lesser or equal to 15% and expresses this as a percentage. In this case answer is 76.2%. I hope this makes sense, Thanks...

Hello anybody can help me solve a formula to check if the inv date fall between a promo allowance and if so get that promo allowance % and multiply by case, below is the data incentive table that im referring, I will like to bring the percentage...

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 guys, I'm sure this is stupidly simple, but my brain doesn't want to point me in the right direction.... I am selling products, I have my purchase cost, my sale price and I want excel to calculate the price of the product after a given % discount. At the moment, if i type in 15% into the...

I would like a quick and easy formula to help calculate profit. Scenario. Suppose I purchased 100 Iphone8 at $1000 each plus 15% tax. In excel: A1=100 B1=$1000.00 C1=15% I tried to sell them and nobody would pay me over $1000.00 for them. So I looked around and found another provider that...

Can I write an Ifs statement that contains several inequalities? Below are the criteria: If Cell >=15% then value= 1 If cell is between 6%-14% then value= 2 If cell is between -5% and 5% then value = 3 If cell is between -6% and -15% then value = 2 If cell is less than -15% then value = 1

I've created a spreadsheet which monitors the daily weights of animals and added conditional formatting so if the cell drops below 20% of their body weight it turns red I have the following formula where it calculates 20% of body weight of an animal =D4%80 that was easy but I'm having...