+ Reply to Thread
Results 1 to 5 of 5

Is it possible to create a formula, in one cell, that will add text to a different cell?

  1. #1
    Registered User
    Join Date
    06-19-2012
    Location
    Irving, TX
    MS-Off Ver
    Excel 2010
    Posts
    13

    Is it possible to create a formula, in one cell, that will add text to a different cell?

    I have been googling this all morning...

    Is it possible to have a formula in one cell that will create text in a different cell?

    I can create a formula directly in the cell that I want to house the text... but as soon as it gets written over, it is gone...
    I tried using the formula in Data Validation and Conditonal Formatting, but neither one of them produced the results I want.

    If I type this formula into BO21:
    =IF((B21="Baggage Fees"),"Enter number of bags checked","")
    I get the message "Enter number of bags checked" to appear in the cell. I want the user to enter in the number of bags they checked. Based on that number, another cell has a formula...

    Problem is, once they type in the number, they write over the formula.

    So, can I create a formula in BO1 that will create text in BO21?

    I tried this, but it didn't work:

    =IF((B21="Baggage Fees"),(BO21="Enter number of bags checked"),(BO21=""))

    Help!!
    Annie

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    13,764

    Re: Is it possible to create a formula, in one cell, that will add text to a different cel

    You get better help if you post an Excel-example of your workbook, without confidential information.

    Make sure the workbook demonstrates your desired results if possible, or just highlight the cells you're trying to fix.

    Use BEFORE/AFTER sheets if that helps make it clearer.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Registered User
    Join Date
    06-27-2012
    Location
    Washington, DC
    MS-Off Ver
    Excel 2010
    Posts
    11

    Re: Is it possible to create a formula, in one cell, that will add text to a different cel

    What you are trying to do, can not be done through excel built in formula, but can very easily be done using VBA. Like oeldere said though, attach a workbook.

  4. #4
    Registered User
    Join Date
    06-19-2012
    Location
    Irving, TX
    MS-Off Ver
    Excel 2010
    Posts
    13

    Re: Is it possible to create a formula, in one cell, that will add text to a different cel

    Audit Sample for Excel Forum 6.29.2012.xlsx

    I am attaching a sample file.

    I want:
    M3 to say "Enter number of bags checked" if "Baggage Fees" is selected from the dropdown in B3

    I then want the User to type in the number of bags checked into cell M3
    If their entry is greater than 2,3,4 or 5 then cell AE3 will turn red and say "Comment Required"

    I would like the formula to be if M3>1 then show "Comment Required" - but the formula in AE3 is seeing the formula in M3, and deciding it is "greater than 1".

    Also, I am pretty sure my formula in AD3 could be written better.
    =IF(OR(B3="",OR(C3="",J3="",L3="",O3="",X3="",AC3="")),"You do not qualify for this expense",IF(OR(B3="Baggage Fees",M3<1),"Reimbursable","Reimbursable"))

    What I am trying to get it to do is say that the following cells MUST be populated:
    B3
    C3
    J3
    L3
    O3
    X3
    AC3

    AND if
    B3="Baggage Fees" then cell M3 must also be populated
    the end result will be that "Reimbursable" should appear, if all the cells are populated... if not, they should get a message saying "You do not qualify for this expense"

    What I'd REALLY like... is for:
    All the cells above cannot be blank and if B3="Baggage Fees", then cell M3 has text that says "Enter number of bags checked" and that field must be populated with a number. If the number entered into cell M3 is greater than 1, then cell AE3 says "Comment Required" and cell AD3 says "Reimbursable" - preferably when the text changes in AE3 Attachment 165024Attachment 165024from "Comment Required" to whatever the user types in.

    I think I am asking for magic, but I don't know.

    Any help would be greatly appreciated! If the answer is that it can't be done, then just put me out of my misery, so I'll stop trying! :-)

    Thanks much!
    Annie

  5. #5
    Forum Guru (RIP) Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    7,218

    Re: Is it possible to create a formula, in one cell, that will add text to a different cel

    As already stated, this can't be done with native functions. A cell can be either a value or a formula not both.

    Why not use M2 for your formula, and M3 for your value?

    See this example using C/F to highlight the cell that requires a value.
    Attached Files Attached Files
    Last edited by Marcol; 06-29-2012 at 01:30 PM. Reason: Updated to suit OPs example
    If you need any more information, please feel free to ask.

    However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....

    Also
    اس کی مدد کرتا ہے اگر
    شکریہ کہنے کے لئے سٹار کلک کریں
    If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.

+ 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