What function to copy text to another cell?
I want to say in one instance:
I type 'GREEN' in cell A1, and in cell B1 I want a function to = whatever I
type in A1, so when I press the enter key in A1, B1 also shows the word
"GREEN" ?
The second one is more complicated!
I want to say:
If cell A1 0 , then show the text contained in cell B1 in cell C1. What
function do I type into C1 ?
Please Help!
|