Microsoft Excel Functions & Formulas

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.

4

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

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.

4 Chapter 1

Figure 1-3