×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Copy cell from sheet # 2

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.

RE: Copy cell from sheet # 2

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,"")

I think!








Cheers

Greg Locock

RE: Copy cell from sheet # 2

(OP)
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.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources