# A text response to a value

#### obliter8

##### New Member
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

### Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce
Try:

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

Do you mean something like this?

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

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

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.

obliter8 said:
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"}),"")

Replies
10
Views
165
Replies
3
Views
218
Replies
5
Views
142
Replies
4
Views
106
Replies
7
Views
229

1,207,013
Messages
6,076,149
Members
446,187
Latest member
LMill

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back