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