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.