Ok, I tried the =IF(D6>D7,D6*1/D8&" DOWN", D7*1/D8&" UP") but it comes up in a fractional value instead of percent.
0.558823529411765UP

Also tried the =IF(B6>B7,B6*1/B8,B7*1/B8)&" UP" but again the total comes up in fractional.
0.730769230769231 UP

I'm not sure if I explained what I'm trying to accomplish clearly... I'm trying to get either the "Up" or "Down" value according to thecalculation.

=IF(B6>B7,B6*1/B8,B7*1/B8)

15+14=29 or 52% Up
14+15=29 or 52% Down

Please advise what I'm doing wrong.

Thanks