Calculating Price Reductions in Excel
In this example, we have a Price list and certain prices need to be reduced by 10%. Here is how we are going to achieve this.:
How to Reduce Prices by a certain percentage
- Open up Microsoft Excel (Formula can be used in virtually any version of Excel).
- For this example, we are going to assume that the names of products are in cells A5:A10 and the prices are in B5:B10.
- Now, select an empty cell. For this example we’ll select cell C1. In it, type -10%.
- Select cells C5:C10
- Enter the following formula: =B5+(B5*$C$1).
- Press CTRL+Enter
In order for this formula to work properly, both columns B and C should be formatted in the Currency Style and it must have an absolute reference to cell C1. Thats it!
