Formulas cannot move or copy.

You would need a fourth cell with a formula like =IF(A1=B1,C1,"not equal")

Note: minimal error-trapping in the formula posted.

To actually copy or move you would need VBA


Gord Dibben MS Excel MVP

On Tue, 30 Dec 2008 11:09:01 -0800, Mike
wrote:

Need a formula to compare the content of two cells and if equal, move (copy)
the content of a third cell to another cell. Any help would be appeciated.

Mike