Say that your result of -10% is in Cell B4, then the following formula would
yield a result of "fell 10%"

=IF(B4<0,"Fell "&-B4*100&"%","Rose "&B4*100&"%")

You can replace Fell and Rose with Down and Up if you wish.

Hope this helps!

If so, click yes please!


"DOUG" wrote:

Is there a way to substitute the words "UP" or "ROSE" and "DOWN" or "FELL"
for a calcualted value referenced in another cell in a concatenated statement
combining text and the cell reference? (So, instead of saying "In May, such
and such a value was -10%", I would be able to say it "fell 10%").

DOUG ECKERT