Can anybody help me? I'm wondering if this would be possible and if so, how do I do it?
I want to create a excel sheet where if I were to type in a certain value, (let say in cell a1) a certain phrase will show up in (let say in cell b1). Would this be possible?
For example, in cell [a1] I will type in the value of: 1996. By doing so, I want cell [b1] to give a phrase of: This is the year of so and so.
So [a1] is the input and [b1] is the output phrase
Where input value 1996= this is the year so and so
Where input value 1997= this is not the year so and so
Any ideas? I have a lot of books and I don't mind doing all the research, I enjoy it, but I need someone to give guidance along with some creative insight on how I should go about in doing this. Thanks you
Can this idea be executable by excel alone or do I need to use access or VBA or macro?
2006-11-22
10:18:53
·
2 answers
·
asked by
Inquisit
2