Calculate a price reduction
All prices in a price list have to be reduced by a certain percentage. The amount of the price reduction is 15% and is entered in cell C1.
To reduce all prices by a certain percentage:
- In a worksheet, enter your own data or the data shown in figure shown below.
- Select cell C1 and type -12% and then select cells C4:C8.
- Enter the following formula: =B4+(B4*$C$1).
- Press Ctrl+Enter.
Please note that the formula must have an absolute reference to cell C1. Also, columns B and C are formatted with the Currency style, which is available by clicking on the $ button on the Formatting toolbar.