Copy cell from sheet # 2

[Eurobum]

I'm using IF('sheet 1'!A1>0,'sheet 2'!A2=A1,'sheet 2'!A2="&quot
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.

 

[GregLocock]

That's because you've entered another test as the outcome of your IF statement, isn't it?

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,"&quot

I think!








Cheers

Greg Locock

 

[Eurobum]

Thank you Greg,

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.