Percentage Change

[Harley]

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%

 

[lenze]

=(C2-B2)/B2

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

 

[NateO]

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
	A	B	C	D
1	IncellB2Ihave282.IncellC2Ihave70.Thisisadecreaseof75.2%.
2	IsthereaformulaIcanuseincellD2thatwouldautomaticallyenter-75.2%	282	70	-75.2%
3	IncellB3Ihave56.IncellC3Ihave214.Thisisanincreaseof73.9%.	56	214	282.1%
4	IsthereaformulaIcanuseincellD3thatwouldautomaticallyenter+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