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=.20B3

3=B3-B3*20

4=B3-20%

Question

Computers & Technology

Ulises Bush

29 June, 11:21

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=.20B3

3=B3-B3*20

4=B3-20%

+2

Answers (1)

Know the Answer?

Jaiden Briggs · 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.

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*.82=.20*B33=B3-B3*204=B3-20%

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=.20B3

3=B3-B3*20

4=B3-20%