Adding text to a formula?

**cocco** · 03-08-2012, 12:13 AM

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

**DGagnon** · 03-08-2012, 12:28 AM

Try these:

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

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

**vlady** · 03-08-2012, 12:32 AM

or inside the if statement...

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

=IF(D6>D7,D6*1/D8&" DOWN", D7*1/D8&" UP") - change as needed

**cocco** · 03-08-2012, 10:43 AM

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

**darknation144** · 03-08-2012, 11:37 AM

Do you mean Round up or Round down? therefore you can use =roundup() or =rounddown()

Please post what is in B6 B7 and B8 you formula

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

Doesn't match 15+14=29 or 52% Up
at all.

Do you want it to say "up" if a value is above X and "down" if a value is below X?

**DGagnon** · 03-08-2012, 01:44 PM

try this:

=IF(D6>D7,TEXT(D6*1/D8,"%0.0")&" DOWN", TEXT(D7*1/D8,"%0.0")&" UP")

because you are going to be using text instead of a number format once you add letters to your output, you need to format in the formula instead of in the cell.