CALCULATE A PRICE REDUCTION USING MICROSOFT EXCEL

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:

1. In a worksheet, enter your own data or the data shown in Figure 1-3.
2. Select cell C1 and type -15%.
3. Select cells C4:C8.
4. Enter the following formula: =B4+(B4*$C$1).
5. Press <-Ctrl+Enter->.

CALCULATE A PRICE REDUCTION USING MICROSOFT EXCEL

Note: 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.

Watch the Video Tutorial

Microsoft Excel Tutorials, Microsoft Excel Video Tutorials, Excel Tutorials using Macro, Formulas in Excel, Calculate A Price Reduction Using Microsoft Excel, General Formulas In Excel