A formula to discount percentage
I have a quote template which displays the unit price, discount and total payable. What I need is to be able to enter the discount (in percentage format) being offered on the unit price and then have that percentage discount automatically calculate in the Total Payable cell. The discounts can vary, so the formula will need to allow for changing unit prices and discounts. The cells being used are E17(Unit Price), F17(Discount) and G17(Line Total).
Would like to have the option to discount a list of sales items by either plugging in a discount OR a dollar amount on the same row.
I am trying to figure out how to get a percentage to show up in certain cells.
THis is what I have:
C D E F
List Price Retail Price Wholesale Sponsor1 Sponsor2
20.00 49.95 =8%*D2 =7%*D2 =6%*D2
SHOWS AS 4.00
Ok the formula =8%*D2 shows the discount amount of 3.996 but what I want to do is show the actual cost. So if I subtract 8% from 49.95 the discount would be 3.996 so in E I would want the Cell to show 45.954 which reflects the discount. Same goes for F and G.
as part of my IT 2 course I am required to apply a VLOOKUP formula, using the VLOOKUP function, to give a percentage discount if students pay so many days in advance of a course starting date. ie 10% discount for 20 days or more prior to course start date, 8% discount 14 to 20 days prior, 5% discount 7 to 13 days. Any help would be greatly appreciated. I have been working extensively to solve this problem myself, obviously without success.
I am trying to speed up my stock take this year using excel but im useless.
I need to multiply the product value by the amount and then take off discount written in percentages. Also most percentage discount will vary due to the product and there is about 300 products
Product value £10
First discount 5%
Second discount 2.5%
I was looking at setting out it like this
Product amountTrade price Discount 1 Discount 2 total
bait clip 20 10 5.00% 2.50% 185.25
Related Applications & Scripts
This package contains 3 galleries & banners. The discount is ~ 40% and you will also receive BONUS an Advanced Video Player with Playlist and Categories.
You do not need to know Flash in order to set the components. Every setting can be done in a main.xml file making it very easy to update.
Super Video Players Pack - 53% Discount. This amazing package contains 3 super video players. The discount is ~ 53%.
You do not need to know Flash in order to set the video player. Every setting can be done in a main.xml file making it very easy to update. You can set this player to any size you want from the configuration XML file, changing the player width , the player height and the playlist width. You can easy integrate this in any projects you need, HTML or Flash.
This package contains:
- First Class Video Player - FLV/H.264/MP3 - Google Analytics & Subtitles
- Universal Video Player - FLV/H.264/MP3/YouTube - Google Analytics & Subtitles
- Ultimate Video Player - FLV/H.264/MP3/YOUTUBE
Smooth animated percentage preloader that is simple to use and visually appealing.
Easy to use:
Simply copy the on stage mc to your flash files first frame.
- Percentage based preloader for loading your flash movie
- Copy and paste movieclip
- Paste preloader mc on the first frame of your movie and add a stop action
- AS 3 .0
- All Vector
- Fully skinnable
Additional payment calculator
How much do you save by paying more or making additional payments than your initial mortgage terms?
Monthly payment calculator
Want to know how much your monthly payment is for your mortgage?
How much do I have to earn?
Not sure how much money you'll have to earn to afford your house payment and accompanying expenses?
How much can I borrow?
Want to know how big of a mortgage you can take on?
Should I pay discount points?
Not sure if you should pay discount points on your mortgage loan?
How much will I save by refinancing my loan?
How long will it take to recoup the costs of refinancing my home mortgage?
How much will my tax deduction be?
Want to know how much your home mortgage will save you in taxes?
Bi-weekly mortgage calculator
Want to know how much time and money you'll save paying off your loan on a bi-weekly payment plan?
To find out the annual percentage rate of your loan, enter the loan amount, interest rate, points, other costs
and year-length term.
Interest only monthly payment calculator
To find out the monthly savings you could gain from an interest-only payment plan.