If A1 contained the percentage, you could use a formula like:

="In May, such and such a value "
&TEXT(A1,"""rose ""0%;""fell ""0%;""stayed even""")

The =text() function has 4 parts:
positive;negative;zero;text

I didn't touch the text portion.




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

--

Dave Peterson