Formula between two numbers show as percentage up and down

[asyamonique]

Good Day,
Can you please help me on that given formula below?
I couldn't find out to make the formula result if the percentage needed to show as negative.
If column D has a negative numbers it doesn't give correct result.
Thanks

IFERROR(IF(D2="","",((D2-C2)/C2)*IF(OR(AND(D2<0,C2),AND(D2<0,C2>0)),-1,1)),"")

 

[jtakw]

Hi,

Can you explain in words what your requirements are when C2 and/or D2 are positive and/or negative, and how that affects the result?

 

[asyamonique]

Hello,
Is there any way to show on second row negative value on column C ?

15,000	7,500	-50.0%
15,000	(7,500)	150.0%

 

[jtakw]

Hello,
Is there any way to show on second row negative value on column C ?

15,000	7,500	-50.0%
15,000	(7,500)	150.0%

If that's all you want, I don't see the need to Test D cell for negative, unless I'm not understanding fully.

Book3.xlsx
	C	D	E
1	15,000	7,500	-50.00%
2	15,000	-7,500	-150.00%
3	15000
4	15000	25000	66.67%
Sheet942

Cell Formulas
Range	Formula
E1:E4	E1	=IF(OR(C1="",D1=""),"",(D1-C1)/C1)

EDIT: added to formula to Test C cell for blank.

 

[asyamonique]

Yes thanks for your help.?

 

[jtakw]

You're welcome.

 

[asyamonique]

You're welcome.

One more issue,
From negative to positive?
It should be positive result.

100	(50)	-150.0%
(50)	100	-300.0%

 

[jtakw]

What if they're Both negative, ie (C2=-50, D2=-100), should the result be positive or negative?

 

[asyamonique]

(50)	(100)	(50)
(100)	(20)	80
(300)	(500)	(200)
(700)	(200)	500

 

[jtakw]

(50)	(100)	(50)
(100)	(20)	80
(300)	(500)	(200)
(700)	(200)	500

Not sure if I follow, how did you come up with the E column results, it doesn't look like there's a Percentage relation between C & D, it looks more like, if Both C & D are negative, you just want the difference between the two?