34. Calculate percentage of price reduction
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.
Watch the Video Tutorial - https://www.youtube.com/watch?v=tqcZA2rVvkk
Hope You Like This Tutorial - Give Comments
No comments:
Post a Comment