And what should the value of "another cell" be if the third cell has no
data?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Derek" wrote in message
...
I want to copy data from on cell to another cell, but only if a third cell
has data in it.