# Excelforum.com discount code

## Discounted Value Based On A Percentage

Discount excelforum.com

how do we know what discount to apply So if column A is 90% no discount would be applied, if 60% £10.00 discount, if 15% £20.00 discount not sure I fully understand how it works can you give an example of what you would like in columns C,D or E based on the values you currently have in A and B on your example

108 People Used
Expires: August, 2021

## Need Help With A Different Price

Stickers excelforum.com

the more stickers my customer buys the more discount they get. for example: 2" X 2" stickers 50 stickers = \$58 100 stickers = \$70 - 40% discount 200 stickers = \$92 - 60% discount 300 stickers = \$112 - 68% discount 500 stickers = \$147 - 75% discount 1,000 stickers = \$225 - 81% discount 2,000 stickers = \$225 - 84% discount

115 People Used
Expires: February, 2021

## Dynamic Multiplication

Month excelforum.com

• The idea is that the first month tickets will be sold at a promo price of 60%/70% of full price depending on destination, 2nd month of 70%/80% and etc etc until the 5th month where prices stabilize to full price
• So the start of a new destination will face promo prices for the first 4 months
• That is where the 60% 70% 80% 90% come in.

94 People Used
Expires: February, 2021

## Calculate % Discount For Full Column

Discount excelforum.com

• Hi all, sorry if you all think this is a stupid question but I have never used excel before
• I am trying to create a formula for a column that will display a total with discount misused
• I can do the calculation for each individual row, but don't know how to do this for the column as the price and quantity of each item changes on every row
• I have an item price column, quantity and a discount

91 People Used
Expires: June, 2021

## Financial Rate, PTM, PPMT

Monthly excelforum.com

• The monthly rate is 5% , the annual rate is 5X12= 60 % 4
• With the condition to pay the monthly paymant on the contractual date , the bank give one discount of 1% monthly to the monthly 5%
• ;ut if the monthly payment is not made in …

97 People Used
Expires: May, 2021

## Formula For A Sliding Scale Fee

Return excelforum.com

• Hi Everyone, I am trying to write an Excel formula that calculates the fee a client would pay for the return on an investment
• Let me give you an eaxple of what I mean: Say a client invests \$100 000 and the return over a year is \$160 000, and the return of the benchmark S&P 500 is 10%
• Then I would like to develop a formula that charges the client on a sliding scale depending on the exceedence

105 People Used
Expires: January, 2021

## How Do I Subtract 20% From One Column In Excel And Place

Effect excelforum.com

=A30*80% assuming totals in A30--HTH RP (remove nothere from the email address if mailing direct) "Full Effect Landscaping" <Full Effect [email protected]> wrote in message news:[email protected]

124 People Used
Expires: July, 2021

## Calculating % GP Anyone

Charge excelforum.com

Hey guys, Basically im running a new bar in Leeds and im trying to create a spreadsheet which will tell me how much to charge per drink to gain a 80% GP on products, ive got as far as listing the products and prices and calculating how much every measure (25ml) will cost. In the past ive used formulas where I can input the price i charge and it will calculate the GP (=SUM(D10/E10)*100-100) …

82 People Used
Expires: March, 2021

## Calculating Percentage And Cost Of An Item

Percentage excelforum.com

• I am having an issue with figuring out a percentage and total cost of an item
• In the example below I have 10 gift cards, the first has a face value of \$120, I got it for free (Paid), the difference between is \$120 giving me a 100% discount and so on
• It gets hazy for me when we get down to the \$189 gift card, is the percentage (saved) correct for those 4 that I paid for? and is the total

105 People Used
Expires: February, 2021

## Progessive Discounts Table [SOLVED]

Expensive excelforum.com

Progessive Discounts Table I have a sheet where I want to calculate de progressive discount based on the more expensive and progressively. It works Like this: when the patient will do a surgery (3 or 4) he will pay the 100% of more expensive procedure, 50% from de second more expesive and 30% of the third more expensive.

105 People Used
Expires: May, 2021

## Need Formula Or Function To Calculate Margin (reverse Of

Number excelforum.com

• I need function to calculate the reverse of adding percent margin to a number (e.g
• For example, I have a number 100, and I want to identify the number that will result in 100 after 40% deduction (discount)
• I am looking for a formula or function in excel that will result in 166.67
• Note that 166.67 - (166.67 * 40%) will result in my original number of 100.

144 People Used
Expires: July, 2021

## Creating A Cross Tab Table Automatically Based On Two

Discount excelforum.com

• I have a profit equation for a product that gets impacted by a discount (cell E4) The discount applied impacts the profitability of the product
• As discount increases, profit declines
• The discount also impacts the conversion rate of a marketing ad
• An increase in conversion rate impacts the breakeven cost per lead
• BUT this breakeven cost per lead is also impacted by profit.

129 People Used
Expires: April, 2021

## Formula/Macro For Adding Values That Meet Certain

Monthly excelforum.com

• The monthly rate is 5% , the annual rate is 5X12= 60 % 4
• With the condition to pay the monthly paymant on the contractual date , the bank give one discount of 1% monthly to the monthly 5%
• ;ut if the monthly payment is not made in …

159 People Used
Expires: December, 2021

## Computing Loan Repayment & Annuity,

Years excelforum.com

• David is a 40 year old South African
• He obtains a loan from the local Bank on 1 January 2012
• The terms and conditions of the loan are as follows: Loan amount R 900 000 interest rates (p.a
• effective): 7.97% for the first 7 years 12.38% for the next 8 years 11.49% for the last 5 years The loan is repaid by level monthly payments in arrears for 20 years David uses the loan to buy a house in

103 People Used
Expires: September, 2021

## If Equal To Or Less Than Formula [SOLVED]

Trying excelforum.com

• Hi, Have a problem trying to get a formula to work
• I am trying to set a scorecard up where it will give points depending on the % actual
• For example: if less than 60%, then 0, if equal to or greater than 60% but less than 75%, then 1

100 People Used
Expires: January, 2021

## IF This Or That Depending On Dropdown Value

Units excelforum.com

• I am trying to make an invoice with a drop down quantity list
• If the quantity is up to 96 units then 50% discount
• If over 96 units then 60% discount
• Thanks very much for assistance

128 People Used
Expires: March, 2021

## Chart To Show Order Completion Percentage

Products excelforum.com

• Hi friends, Probably the most basic question I am having difficulty with
• I have an order format (Sample file attached)434544 in vich I take order of various products and supply them
• Many times only a few products are supplied
• Hence, in order to prevent those products being sent again, I write OK in front of the product name
• Many times there are more than 200-300 products hence there might

124 People Used
Expires: January, 2021

## Sumproduct Tiered Commission Payment [SOLVED]

First excelforum.com

• Hi, I have used sumproduct formula to calculate tiered commission payments and all works correctly, except if you exceed the threshold on the first deal
• Assuming the threshold is 1,050,000 at 70% and your first deal is 2,000,000 then the payment should be 1,400,000, however the sumproduct formula applied calculates 1,205,000

123 People Used
Expires: May, 2021

## Excel 2007 : Storing Static Formulas That Can Execute

Commission excelforum.com

purchased by a Member (Y11), and if so they get a 10% discount with no loss of commission to the seller, if the seller is eligible for a commission (Z11), if the consignor is donating the item (AA11) and finally, if the consignor has demanded a different commission rate, say, 70% of sale price vs. 60% or sale price) (AB11)

123 People Used
Expires: March, 2021

## Margin/markup Formula For Excel

Price excelforum.com

• I am trying to insert a formula to calculate a percentage of margin/markup
• Example cost = \$7.00 divided by 30 % = \$10.00
• My cost is 7.00, my sale price is …

113 People Used
Expires: January, 2021

## Comparative Charts In Excel For 3 Variables, But Another

Series excelforum.com

create a 2D clustered column with 2 series (with and without discount) set the transparency on the "without discount" series to 50%; right click on either series and set the gap width to 35% (making the columns wider) and the overlap to 60%; you will …

173 People Used
Expires: July, 2021

## Finding Interest Rate / IRR

Check excelforum.com

Check my results, is Agent 25 supposed to return 3.60%? More precisely, 3.59659240544724% (plus 2.78E-17). Then XNPV returns about -3.64E-12 or 4.55E-13, depending on whether or not you round to 15 significant digits.

116 People Used
Expires: July, 2021

## Macro For Splitting The Number To A Specific Proportion

Together excelforum.com

• Lets say the invoice is 100, with 6:4 the result would be 60 and 40 - both integers, together they add up to 100 - that's fine
• Or let's say the invoice is 240, with 6:4 the result would be 144 and 96 - both integers, together they add up to 240 - that's fine

147 People Used
Expires: June, 2021

### FAQ?

#### What is the discount per item?

Depending do you have discount per item or total discount.. the discount will always be 30%, but the item amount and quantities are always different. There are many, many rows so instead of writing the formula in every cell in the column, I thought there would be a way to apply a formula to the entire column.

#### What is the discount of a column?

the discount will always be 30%, but the item amount and quantities are always different. There are many, many rows so instead of writing the formula in every cell in the column, I thought there would be a way to apply a formula to the entire column. I thought it would look something like this: = (F/100*70). Jordan, just copy the formula down.

#### What is the percent discount in Excel?

Anyone knows how does Excel handles this, or know of a formula that can handle this. 60% discount. That is 250 - (250 * 60%). and 100 and 60% with result of 250. Thanks a lot.. and your percent is in A2, then A3 = a1 / (1-a2). Hope this is what you need. "Ken" <[email protected]> wrote... ....

1. The list of discount codes we provide has 19 Coupon Codes and 4 Deals. Most of them are valid, but we're not 100% sure they can be used.

2. The list of discount codes we provide has 23 results. Most of them are valid, but we're not 100% sure they can be used.

3. You just need to click GET CODE and get to the destination page, enter the code. However, you have to take action early as it may expire.

### New Deals

##### Free Ebook On How To Write A Perfect Cv

1 hours ago Free ebook on how to write a perfect CV ...

##### Cardialarm

5 hours ago art herrenschuhe iphone 8 plus clear hoesje speck mens nike baltimore ravens 65 ...

##### 20% Off Entire Online Order

20 hours ago Limited Time: Valid for 20% OFF entire order at LookNowDeals.ca/Store ...

##### Numptydomains

1 days ago tools home improvement door viewers 1 home kitchen bakeware food coloring home k ...

##### Hubertheating

1 days ago converse chuck taylor noir homme jordan retro 5 rojo suede detroit tigers classi ...

##### Sliptest

1 days ago nike sb dunk eric koston nfl tanoh kpassagnon blackcamo 92 kansas city chiefs ni ...