What function to copy text to another cell?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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!
Click to expand...

1st question
=A1

2nd
=if(a1>0,b1,a1)
 
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(A1>0,B1)

Hope this will clear your doubts.

Regards,
Soundar
 
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.
 
Back
Top