=IF(A1="OK","",B 1)

but this is caveated with the fact that it cannot go into A1, as you can't
test itself.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Gerrym" wrote in message
...
I have a formula which chacks the contents of a cell, if
it is ok I want to leave it otherwise I want to copy the
contents of another cell into the active cell. How do I do
this