how to calculate difference in percentage when numbers are minus

[arniebun]

hi i have attached an example. if you look at row 198 and 199 i have a number that is -3.8 and -27.4 i want to calulate the diffrence in percentage. which should be -627.29% not 627.29%. what i need is a formular that will do this and calculate the percentage of the other numbers in my sheet. it works with some numbers but not with others. was woundering what i am doing wrong, or why my current forumlar is doing this.

please help!!

 

[Alex Blakenburg]

See if this is what you want:

Book1
	C	D
199	-12.9
200	-13.1	-1.55%
201	-13.7	-4.58%
202	-6.5	52.55%
203	7.6	216.92%
204	3.4	-55.26%
205	-3.8	-211.76%
206	-27.4	-621.05%
207	-41.7	-52.19%
Sheet1

Cell Formulas
Range	Formula
D200:D207	D200	=(C200-C199)/ABS(C199)

 

[arniebun]

=(C200-C199)/ABS(C199)

purfect thanks a million

 

[Alex Blakenburg]

Thanks for letting me know. Glad I could help.