# How to Apply a Percentage Increase or Decrease in Excel

You can use the following basic formulas to apply a percentage increase or percentage decrease to values in Excel:

Method 1: Apply Percentage Increase

```=A1*(1+B1)
```

Method 2: Apply Percentage Decrease

```=A1*(1-B1)
```

In both formulas, cell A1 contains the original value and cell B1 is the percentage that we’re increasing or decreasing the original value by.

The following examples show how to use each formula in practice.

### Example 1: Apply Percentage Increase to Values

Suppose we have the following list of values in Excel:

We can use the following formula in cell C2 to apply a 25% increase to the value in cell A2:

`=A2*(1+B2)`

The following screenshot shows how to use this formula in practice:

Each value in column A has been increased by 25%.

For example:

• 10 has been increased by 25% to 12.5.
• 15 has been increased by 25% to 18.75.
• 18 has been increased by 25% to 22.5.
• 20 has been increased by 25% to 25.

And so on.

### Example 2: Apply Percentage Decrease to Values

Once again suppose we have the following list of values in Excel:

We can use the following formula in cell C2 to apply a 10% decrease to the value in cell A2:

`=A2*(1-B2)`

The following screenshot shows how to use this formula in practice:

Each value in column A has been decreased by 10%.

For example:

• 10 has been decreased by 10% to 9.
• 15 has been decreased by 10% to 13.5.
• 18 has been decreased by 10% to 16.2.
• 20 has been decreased by 10% to 18.

And so on.