Hello,

I'm trying to figure out how to add text "UP" or "DOWN" to the following percentage formula?

54% UP

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

54% DOWN

=IF(D6>D7,D6*1/D8,D7*1/D8) "DOWN"

Please advise...

Thanks