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?