A text response to a value

[obliter8]

Hi

i need a formula that will give me a text response to a value....

if the value is zero i would like it to return the text "BALANCED",
if the value is greater than zero i would like it to return the text "OVER",
if the value is less than zero i would like it to return the text "SHORT".

Can this be done?

Thanks

 

[Von Pookie]

Try:

=IF(A1="","",IF(A1=0,"BALANCED",IF(A1>0,"OVER","SHORT")))

 

[Norie]

Do you mean something like this?

=IF(A1=0, "BALANCED", IF(A1>0, "OVER", "SHORT"))

 

[obliter8]

umm... i'm not sure if this is the right place to reply.



anyway if it is ...the formula worked perfect...Thank You.

Uhh... if its not too much of a hasle id like to ask another question...

is it possible to choose the color of the font for the the response text?
eg. red for "short", green for "balanced" and blue for "over"

Thank You

 

[Norie]

Not using the formula.

What you need is Conditional Formatting.

Select the cell with the formula in and Goto Format>Conditional Formatting...

Select Cell value is and enter "Short" and format as required.

Repeat for the other 2 values.

 

[Aladin Akyurek]

Hi

i need a formula that will give me a text response to a value....

if the value is zero i would like it to return the text "BALANCED",
if the value is greater than zero i would like it to return the text "OVER",
if the value is less than zero i would like it to return the text "SHORT".

Can this be done?

Thanks

=IF(ISNUMBER(A1),LOOKUP(A1,{-9.99999999999999E+307,"SHORT";0,"BALANCED";2.229E-308,"OVER"}),"")