Excelforum.com discount code

All Time Past 24 Hours Past Week Past month

Discounted Value Based On A Percentage

90% Off 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

90

Get Code

108 People Used
Expires: August, 2021

Need Help With A Different Price

$58 Off 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

$58

Get Code

115 People Used
Expires: February, 2021

Dynamic Multiplication

60% Off 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.

60

Get Code

94 People Used
Expires: February, 2021

Calculate % Discount For Full Column

Deals 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

No Needed

Get Code

91 People Used
Expires: June, 2021

Financial Rate, PTM, PPMT

5% Off 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 …

5

Get Code

97 People Used
Expires: May, 2021

Formula For A Sliding Scale Fee

$100 Off 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

$100

Get Code

105 People Used
Expires: January, 2021

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

20% Off 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]

20

Get Code

124 People Used
Expires: July, 2021

Calculating % GP Anyone

80% Off 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) …

80

Get Code

82 People Used
Expires: March, 2021

Calculating Percentage And Cost Of An Item

$120 Off 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

$120

Get Code

105 People Used
Expires: February, 2021

Progessive Discounts Table [SOLVED]

100% Off 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.

100

Get Code

105 People Used
Expires: May, 2021

Need Formula Or Function To Calculate Margin (reverse Of

40% Off 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.

40

Get Code

144 People Used
Expires: July, 2021

Creating A Cross Tab Table Automatically Based On Two

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

No Needed

Get Code

129 People Used
Expires: April, 2021

Formula/Macro For Adding Values That Meet Certain

5% Off 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 …

5

Get Code

159 People Used
Expires: December, 2021

Computing Loan Repayment & Annuity,

7.97% Off 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

7.97

Get Code

103 People Used
Expires: September, 2021

If Equal To Or Less Than Formula [SOLVED]

60% Off 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

60

Get Code

100 People Used
Expires: January, 2021

IF This Or That Depending On Dropdown Value

50% Off 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

Deals 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

No Needed

Get Code

124 People Used
Expires: January, 2021

Sumproduct Tiered Commission Payment [SOLVED]

70% Off 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

70

Get Code

123 People Used
Expires: May, 2021

Excel 2007 : Storing Static Formulas That Can Execute

10% Off 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)

10

Get Code

123 People Used
Expires: March, 2021

Margin/markup Formula For Excel

$7.00 Off 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 …

$7.00

Get Code

113 People Used
Expires: January, 2021

Comparative Charts In Excel For 3 Variables, But Another

50% Off 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 …

50

Get Code

173 People Used
Expires: July, 2021

Finding Interest Rate / IRR

3.60% Off 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.

3.60

Get Code

116 People Used
Expires: July, 2021

Macro For Splitting The Number To A Specific Proportion

Deals 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

No Needed

Get Code

147 People Used
Expires: June, 2021

Please leave your comments here:

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

About Excelforum.com Discount Code

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

Browse All Deals >>

New Stores

Hickory Farms 10 Off

Promo Code Elk Springs Resort

Toyota Tacoma Off Road Pro

Chicory Coffee Diy

Net Promoter Question Examples

Coupons For Gardein Products

On Quickbooks Online

Cold Creamery Coupons

Groupon For Stanley Steemer

My Old Kentucky Dinner Train Discounts

Beyond Routine Planner

Browse All Stores >>

Watching Now

Easter