Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Percentage Discount
Dealer Cost column has a list of dealer prices. Sale Price is the reduced
dealer cost. I need a column that shows the percentage of discount from Dealer Cost to Sale Price when the price is entered in Sale Price column. Sometimes I would like to enter the percentage of discount and calculate the Sale Price. Any ideas of a fairly simple way to do this so that the printout is understandable to clients? Thank you very much. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Percentage Discount
Discount = (DealerCost - SalePrice) / DealerCost
SalePrice = DealerCost * (1 - %Discount) -- Regards, Fred "Ruth" wrote in message ... Dealer Cost column has a list of dealer prices. Sale Price is the reduced dealer cost. I need a column that shows the percentage of discount from Dealer Cost to Sale Price when the price is entered in Sale Price column. Sometimes I would like to enter the percentage of discount and calculate the Sale Price. Any ideas of a fairly simple way to do this so that the printout is understandable to clients? Thank you very much. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Percentage Discount
If your Dealer cost was in column A you could put this formula in column B
for the Sale price: =100-(C2*A2) and this formula in column C for the % Discount: =1-(B2/A2) You could then copy those formulas down. If you enter a number in the % discoutn it should give you the Sale price. If you enter a number in the sale price it should give you the discount. (Of course once you type in a number it will overwrite the formula in that cell so you could do one or ther other not both. You'd also have to format the % column as %) "Ruth" wrote: Dealer Cost column has a list of dealer prices. Sale Price is the reduced dealer cost. I need a column that shows the percentage of discount from Dealer Cost to Sale Price when the price is entered in Sale Price column. Sometimes I would like to enter the percentage of discount and calculate the Sale Price. Any ideas of a fairly simple way to do this so that the printout is understandable to clients? Thank you very much. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Percentage Discount
Fred and Tim, thank you for your replies. They were very helpful.
"Ruth" wrote: Dealer Cost column has a list of dealer prices. Sale Price is the reduced dealer cost. I need a column that shows the percentage of discount from Dealer Cost to Sale Price when the price is entered in Sale Price column. Sometimes I would like to enter the percentage of discount and calculate the Sale Price. Any ideas of a fairly simple way to do this so that the printout is understandable to clients? Thank you very much. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating a percentage with the end percentage in mind | Excel Discussion (Misc queries) | |||
Percentage Discount Total | Excel Discussion (Misc queries) | |||
Percentage Discount Total | Excel Discussion (Misc queries) | |||
Displaying percentage in ranges in pivot table | Excel Worksheet Functions | |||
Discount rate - what to use? | Excel Worksheet Functions |