40 400 40. Type the original prices and sales prices into a worksheet as shown as below screenshot. The result will always be in decimal form not percentage form.
A percent off of a price typically refers to getting some percent say 10 off of the original price of the product or service.
Convert the percentage discount to a decimal by moving the decimal two places to the left. In this case Excel first divides the discounted price in D5 595 by the original price in C5 70 to get 085 which is then subtracted from 1. Select a blank cell for. Remember the formula for finding the discount price of an item.