Worksheet function

[T. Thomas]

Question:

Is there a formula that will reference a cell, see the
value and then combine the value with a text message?

Example:

Cell # b5 = "3%"

Cell # d7 function would read " if b5 is greater than
zero, then B5 with a text message so the answer would look
like this "3% reduction".

Keep in mind that the cell b5 could range from zero to 100.

Thanks to any and all for you assistance.

 

[Bill Lunney]

You can use the & operator to concatenate text. E.g.

=B5 & " reduction"



--

Regards,


Bill Lunney
www.billlunney.com

 

[Dan E]

=IF(B5>0, TEXT(B5,"#%") & " reduction","Other")

Dan E

 

[Ian]

= b5 & "% reduction"

 

[Tim Otero]

Further shortened to:

=IF(B5>0,B5&"% Reduction","")

You could, of course put anything into the empty quotes. This would show if
the value in B5 was less than or equal to zero. So, you could do something
like:

=IF(B5>0,B5&"% Reduction",B5&"Increase")

tim

 

[Dan E]

Tim

I put in the TEXT(B5,"#%") because I assumed cell B5 was formatted as a
percentage and displayed "3%". Then without the TEXT(B5, "#%") you end up
with "0.03% reduction"

TEXT(B5,"0.00%") works as well if you need decimal places

Dan E

 

[Tim Otero]

My apologies,
I wasn't trying to step on your toes, just provide more information.

tim