Worksheet function

  • Thread starter Thread starter T. Thomas
  • Start date Start date
T

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.
 
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
 
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
 
My apologies,
I wasn't trying to step on your toes, just provide more information.

tim
 
Back
Top