Question

Your manager asks you to calculate the sale price if the product is marked down 20 percent. You enter the original price in cell A2. What formula should you use?
=A2/80
=A2*80
=A2-.80
=A2*.80

Answer 1

Answer:

=A2*.80

Explanation:

THe answer to this problem is =A2*,80 remember that in excel you can do several things, but you have to think the best solution for your problem, the easiest way to solve this would be multiplying the original price for the final price, as the disccount is 20% we withdraw that from the 1 in decimals:

1-,20= ,80

So we know that the final price will be ,80 and we multiply that by the A2 cell which is the original price to obtain the sale price.

Answer 2

The answer is =A2*.80