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]

Here's a suggestion for keeping the percentage ratios, see if this is what you want:

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%
5	100	-50	-150.00%
6	-50	100	300.00%
7	-50	-100	-100.00%
8	-100	-20	80.00%
9	-300	-500	-66.67%
10	-700	-200	71.43%
Sheet942

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

 

[asyamonique]

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?

yes different between two columns as percentage

 

[jtakw]

yes different between two columns as percentage

Then it wouldn't be a "percentage"?, check out my post #11 formula, it accurately shows the percentage Increase/Decrease between D and C relative to C, please let me know if you still Only want the difference if Both C & D are negative.

 

[asyamonique]

Here's a suggestion for keeping the percentage ratios, see if this is what you want:

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%
5	100	-50	-150.00%
6	-50	100	300.00%
7	-50	-100	-100.00%
8	-100	-20	80.00%
9	-300	-500	-66.67%
10	-700	-200	71.43%
Sheet942

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

[/RANGEtHANKS A

Cell Formulas
Range	Formula

Here's a suggestion for keeping the percentage ratios, see if this is what you want:

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%
5	100	-50	-150.00%
6	-50	100	300.00%
7	-50	-100	-100.00%
8	-100	-20	80.00%
9	-300	-500	-66.67%
10	-700	-200	71.43%
Sheet942

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

Many Thanks.
Thats great.

 

[jtakw]

You're welcome.