Discount = (DealerCost - SalePrice) / DealerCost

SalePrice = DealerCost * (1 - %Discount)

--
Regards,
Fred


"Ruth" <Ruth@discussions.microsoft.com> wrote in message
news:9B45E215-D4C1-42BB-B24B-BB0A4FC5350F@microsoft.com...
> 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.