Copy cell from sheet # 2
Copy cell from sheet # 2
(OP)
I'm using IF('sheet 1'!A1>0,'sheet 2'!A2=A1,'sheet 2'!A2="")
to transfer the value of cell A1 to A2 but I always got a False statement even if A1=15.
I think that Excel doesn't allow to copy/transfer the content of one cell to another using IF().
Can anyone help me, please. Thanks.
to transfer the value of cell A1 to A2 but I always got a False statement even if A1=15.
I think that Excel doesn't allow to copy/transfer the content of one cell to another using IF().
Can anyone help me, please. Thanks.





RE: Copy cell from sheet # 2
In english/basic hybrid language you have written:
if Sheet1A1> 0
then
does Sheet2A2=A1? (ie a True or False answer)
else does Sheet2A2=a null string?
And I don't think that's what you really wanted to do at all. At a guess this might be the first time you've tried using IF. It can't throw results into a far-off cell, all it does is fill in the cell that it is in.
I think your intent is :
if Sheet1A1> 0
then
set Sheet2A2 to A1
else
set Sheet2A2 to a null string
In which case you need to type the following into Sheet2A2
=IF('sheet1'!A1>0,'sheet1'!A1,"")
I think!
Cheers
Greg Locock
RE: Copy cell from sheet # 2
I have to put the formula in sheet 1 which controls/updates all other sheets. And youe assumption is right, that's waht I want to do.