# Auto applying text to a cell based on another cells input

1. ## Auto applying text to a cell based on another cells input

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

2. ## Re: Auto applying text to a cell based on another cells input

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

3. ## Re: Auto applying text to a cell based on another cells input

This is absolutely possible, but the execution may depend on what you want to do with it. If your options are:
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.

4. ## Re: Auto applying text to a cell based on another cells input

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?

5. ## Re: Auto applying text to a cell based on another cells input

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

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1