Conditional Move

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
 
J

JE McGimpsey

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

David Biddulph

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

David Biddulph

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