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?