+ Reply to Thread
Results 1 to 5 of 5

Auto applying text to a cell based on another cells input

  1. #1
    Registered User
    Join Date
    04-23-2013
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    9

    Red face 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. #2
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,136

    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","")

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."


    Tips & Tutorials I Compiled | How to Get Quick & Good Answers

  3. #3
    Registered User
    Join Date
    12-16-2012
    Location
    Austin, TX
    MS-Off Ver
    Excel 2010 & 2007
    Posts
    66

    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:
    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.
    If I helped you, please give me reputation.

  4. #4
    Registered User
    Join Date
    08-20-2012
    Location
    High Wycombe, England
    MS-Off Ver
    Excel 2010
    Posts
    46

    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. #5
    Registered User
    Join Date
    04-23-2013
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    9

    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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