View Single Post
  #3   Report Post  
Old December 15th 04, 02:21 PM
Gary Rowe
 
Posts: n/a
Default

Try putting "Shpt Volume Increased" and "Shpt Volume Decreased" in separate
cells, say A1, A2, bold the Increased and Decreased words and then refer to
them in your formula: =IF(H18=0,CONCATENATE($A$1,TEXT(H18,".0%"),"
Y-O-Y"),CONCATENATE($A$2,(TEXT(-H18,".0%"))," Y-O-Y"))



"Rita Palazzi" wrote:

Windows XP Professional
Office 2000

I have a formula that produces a sentence based on the value of a cell:

=IF(H18=0,CONCATENATE("Shpt Volume Increased ",TEXT(H18,".0%"),"
Y-O-Y"),CONCATENATE("Shpt Volume Decreased ",(TEXT(-H18,".0%"))," Y-O-Y"))


I want the word "Increased" or the word "Decreased" to be bold in the
resultant cell. Does anyone know the correct way to achieve this?

Thanks in advance for any help you may provide!

Rita Palazzi
Senior Engineer / Global Trade Services
FecEx Express