Pages

Wednesday, November 3, 2010

Calculate percentage of price reduction - Formulas In Excel - Microsoft Excel Tutorials


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

Submit Site to Google Free Articles Search Engine Submission - AddMe Directories Suggest Link Business Directory AutoBackLinks Directory Bingo Bahia Submission Software Reviews