Need help returning a negative percentage

[Tirrazo]

Hi,


I want excel to show me that the change in percentage for this price result is negative;

Starting price: 60.61
Ending price: 48.97
There is a 19.2% decrease and I would like it to show in the cell: -19.2%

The other way around:
Starting price: 48.97
Ending price: 6061
There is a 23.77% increase and I would like it to show in the cell: 23.77%


The formula I am using:

Regards

 

[johnny51981]

All you need to do is swap your subtraction.

=G9-F9

Then you will get the same result in the negative.

 

[Eric W]

Try:

Book3
	A	B	C	D
1		Start	End	% Change
2		60.61	48.97	-19.20%
3		48.97	60.61	23.77%
Sheet25

Cell Formulas
Range	Formula
D2:D3	D2	=(C2-B2)/B2

I just formatted the cell as a percent with 2 decimals.

 

[offthelip]

try :
=(G9-F9)/F9

 

[BSALV]

Map1
	B	C	D
3	60,61	48,97	-19,20%
4	48,97	60,61	23,77%
Blad1

Cell Formulas
Range	Formula
D3:D4	D3	=+(C3-B3)/B3
B4	B4	=+C3
C4	C4	=+B3

 

[Tirrazo]

Thank you both, will test this