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
Bookmarks