Calculating Discount

Hi, everyone. I am taking an Excel class and working on a project. I need some help calculating the discounted price of something. What I did is divide the price of something by the percent of discount. Example $15.50/15%. Some of the cells have 0% discount because they don't get one. When I fill in the formula I get an error #DIV/0!
because the discount value is 0. How can I fix this. I have to compare to see how much the discount of sales can affect the total amount of sales.

Thank you for any help you can offer.

Debbie

EDIT: I think I figured it out. I had my thinking wrong. I think I have to multiply the cell with the discount with the cell with item price.

Hello Debbie,

Are you sure you want to divide? How do you calculate 50% of 60? What result do you get if you use

=60/50%

?

I think you're looking for something closer to original price * (1-discount percentage)

Hi DebbieH and welcome to the forum.

Dividing by the discount is the wrong math operation.

Do an example with real numbers to see if it makes sense. Take a $100 price and reduce it by 15%.
What is your answer? Does $100 / 15% give you what you expected? (I get $85).

Keep learning!!