Auto applying text to a cell based on another cells input

**Dutch67** · 04-23-2013, 09:30 AM

Hi All

I am new to excel & forums but wanted to ask a quick question to see if anyone can help. I am trying to create a spreadsheet for work and can't work out how to simply do the following.
If a value is entered in cell D2 i.e. 50 can I auto populate some pre determined text in cell E2??

For example: If the value in D2 is entered by a user as a number between 0 & 50, can I auto populate some text in E2 such as "You are tracking ahead of budget"?

Hope someone can help me

Thanks
Paul

**benishiryo** · 04-23-2013, 09:38 AM

hi Paul, welcome to the forum. try:
=IF(AND(D2>=0,D2<=50,D2<>""),"You are tracking ahead of budget","")

**jkray622** · 04-23-2013, 09:39 AM

This is absolutely possible, but the execution may depend on what you want to do with it. If your options are:
0-50 = Ahead of Budget
51-60 = On Target
61+ = Behind Budget
Then this code would work (if your value were in A1).

Please Login or Register  to view this content.

Then, you might as well just do conditional statements. If you have many criteria, then there are other options (like lookup tables) that you may want to consider. Let us know what you are trying to do.

**djauncey** · 04-23-2013, 09:42 AM

Hi Paul,

Yes that is certainly possible,

=IF((D2>=0)*AND(D2<50),"You are tracking ahead of budget",0)

So this says if D2 is greater or equal to 0 and less than 50 then put "You are tracking ahead of budget" and if not put 0.

You could also do this if you wanted it to be blank until D2 is filled

=IF(ISBLANK(D2),"",(IF((D2>=0)*AND(D2<50),"You are tracking ahead of budget",0)))

Although that can cause issues if you need to do any further calculations.

Hope this helped?

**Dutch67** · 04-23-2013, 09:47 AM

WOW!!!! You guys are AWESOME!!!!!! They all work so well!!! Many thanks for your quick responses & help & for welcoming me to the forum. I am sure I will be posting again & will definately tell others about it!!!

I Love the internet!!!!

Paul