Conditional Move
 

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

Conditional Move
 

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

In article ,
Mike wrote:

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?

Conditional Move
 

In A4, use the formula =IF(AND(A1=1,A1<=10),A3,"whatever you want in A4 if
your condition isn't satisfied")
--
David Biddulph

"Mike" wrote in message
...
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

Conditional Move
 

If you go down that route, oughtn't it to be =IF(ABS(A1-5.5)<=4.5, A3, "") ?
--
David Biddulph

"JE McGimpsey" wrote in message
...
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, "")

In article ,
Mike wrote:

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?

Conditional Move
 

You're right- I was thinking 0 to 10, not 1 to 10.

Thanks for the correction.

In article ,
"David Biddulph" <groups [at] biddulph.org.uk wrote:

If you go down that route, oughtn't it to be =IF(ABS(A1-5.5)<=4.5, A3, "") ?

Conditional Move
 

Thanks everyone for your help, it is working great.

Mike

"Mike" wrote:

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