# Percentage Change

#### Harley

##### New Member
In cell B2 I have 282. In cell C2 I have 70. This is a decrease of 75.2%. Is there a formula I can use in cell D2 that would automatically enter -75.2%

In cell B3 I have 56. In cell C3 I have 214. This is an increase of 73.9%. Is there a formula I can use in cell D3 that would automatically enter +73.9%

### Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.
=(C2-B2)/B2

Works for both. (I don't think an increase from 56 to 214 is only 73%)

Lenze's should work. There is a similar formula I've used below, I combined it with an "if" statement so that Div/o won't appear if the denominator equals zero, not sure if you need this functionality or not.
Book3
ABCD
2IsthereaformulaIcanuseincellD2thatwouldautomaticallyenter-75.2%28270-75.2%
3IncellB3Ihave56.IncellC3Ihave214.Thisisanincreaseof73.9%.56214282.1%
4IsthereaformulaIcanuseincellD3thatwouldautomaticallyenter+73.9%
Sheet1

Click on the cell with the formula to see the formula in the formula bar, you can copy this into your formula bar in Excel.

_________________
Cheers,<font size=+2><font color="red"> Nate<font color="blue"> Oliver</font></font></font>
This message was edited by nateo on 2002-08-27 13:50

Replies
7
Views
595
Replies
5
Views
401
Replies
7
Views
139
Replies
2
Views
207
Replies
8
Views
239

1,206,711
Messages
6,074,470
Members
446,071
Latest member
gaborfreeman

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back