Question

Some products in Mariah's store are marked down 20 percent. She wants to calculate the new price in a spreadsheet. She enters the original price in cell B3. What should the formula look like?

1=B3*.8
2=.20*B3
3=B3-B3*20
4=B3-20%

Answer 1

The formula would like 1) =B3*.8 because the original price at 20% off is equal to 100% of the original price minus 20% of the original price which equates to 80% of the original price. Converting 80% to decimal notation yields .8 so one can use the formula =B3*.8 to calculate the new price.