Need to add additional text in a formula

Hello,

I have a formula that I need to add some additional text into it. I need to add an "Up/Down" text if the value shows 50%. As it is now it says 50% down.

=IF(B8<1,"Holiday",TEXT(MAX(B6:B7)/SUM(B6:B7),"0%")&" "&IF(B6>B7,"Up","Down"))

I tried the following but it didn't quite work..

=IF(B8<1,"Holiday",TEXT(MAX(B6:B7)/SUM(B6:B7),"0%")&" "&IF(B6>B7,"Up","Down")&IF(B6=B7,"Up/Down"))

I have attached a working file.

Please advise,

Thanks

Yes Haru, that worked perfect! Thank You