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! |
What function to copy text to another cell?
On Oct 3, 4:10 am, dim wrote:
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! 1st question =A1 2nd =if(a10,b1,a1) |
What function to copy text to another cell?
Hi dim,
For first, u can give =A1 in the cell B1. So that you will get same value in both the cells. For the second, u can give the following formula in C1, =IF(A10,B1) Hope this will clear your doubts. Regards, Soundar "dim" wrote: 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! |
What function to copy text to another cell?
LOL, I was making things soooo much more complicated than necessary. Trying
to transfer text instead of numeric values somehow caused a brain freeze! Those methods worked....obviously...you knew they would...anyway! :-D Thanks again. |
All times are GMT +1. The time now is 06:03 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com