Use the percentage formula YP X. In this problem you need to realize that the discount lowers the price of the television so you have to subtract. Youre still paying 60 of the original 80.
C6 1 - D6 In this case Excel first calculates the result of 1 - the value in D6 2 to get 08.
Divide this new number by the pre-discount price. If you know the original price and the discounted price you can calculate the percentage discount. Sale price 100 of regular price 30 of regular price. The percentage discount on the bottle of wine is 20.