CALCULATE PERCENTAGE OF PRICE REDUCTION USING MICROSOFT EXCEL

A digital camera is on sale. The camera’s original price is $250, but it is now available for $131. What is the percentage of the reduction?

To calculate the price reduction as a percentage:

1. Select cell B2 and enter the original price: $250.
2. In cell B3, enter the sales price: $131.
3. Calculate the absolute difference in cell B4 with the formula =B2-B3.
4. Determine the percentage of price reduction in cell B5 using the following formula: =B4/B2.
5. From the Format menu, select Cells.
6. Select the Number tab and click the category Percentage.
7. Click OK.

CALCULATE PERCENTAGE OF PRICE REDUCTION USING MICROSOFT EXCEL

Microsoft Excel Tutorials, MS Excel Tutorials, Calculate Percentage of Price Reduction Using MS Excel, Microsoft Excel Tutorials, Formulas in Excel, Basic Functions in Excel, Microsoft Excel Video Tutorials