View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Doug Doug is offline
external usenet poster
 
Posts: 460
Default Substitute Text for Plus or Minus

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