m4=b4 only if
 

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

m4=b4 only if
 

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.

m4=b4 only if
 

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

A little light on details, to say the least. "You get as good as you give".
Perhaps something like (in M4):

=if(A4="", "", B4)