Conditional Move

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

I have the need to copy the content of a cell to another cell based on the
value of a totally different cell. If A1 is =>1 and =<10, then I need to copy
the content of a3 to a4. Any clues on how to get this to work?

Thanks, Mike
 
Formulae can't copy data from one cell to another, they can only return
values to their calling cells, so one way:

Put this in A4:

=IF(ABS(A1-5)<=5, A3, "")
 
You're right- I was thinking 0 to 10, not 1 to 10.

Thanks for the correction.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Printing 2
Copy By Variable 4
copy data from one worksheet and disregard blank cells 6
How to use cell reference? 9
Excel Import Comments 3
need a macro to copy the data to the following cells 10
Move one cell to another 4
how to copy the contents from last cell 2

Back
Top