Thread: m4=b4 only if
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Joe User[_2_] Joe User[_2_] is offline
external usenet poster
 
Posts: 905
Default 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)