You are here: HomeExcelTutorials

# A formula to discount percentage

## A formula to discount percentage

Price: FREE

I am trying to find a formula to discount by percentage rather than currency

Visit publisher's web-site: A formula to discount percentage

Category and Tags: ExcelTutorials :

## Related Tutorials

### Discount percentage on quote template

Free: Yes
Tags: Excel ›

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

### Either percentage or dollar discount formula

Free: Yes
Tags: Excel › Functions

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.

### Percentage Help

Free: Yes
Tags: Excel ›

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
G
20.00 49.95 =8%*D2 =7%*D2 =6%*D2
SHOWS AS 4.00
WANT 45.95
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.

### VLOOKUP Formula to apply % Discount

Free: Yes
Tags: Excel ›

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.

### using percentages

Free: Yes
Tags: Excel ›

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
For example
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

### Galleries Pack 40% discount + Bonus a Video Player

Free: No
Tags: Flash › Excel Video Players

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 Discount on Super Video Players Pack

Free: No

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
- Ultimate Video Player - FLV/H.264/MP3/YOUTUBE

Free: No

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.

Free: No

- Copy and paste movieclip
- AS 3 .0
- All Vector
- Fully skinnable

### Mortgage Calculators

Free: Yes
Tags: PHP › Excel Calculators

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?
APR calculator
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.