View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Question, Mark Question, Mark is offline
external usenet poster
 
Posts: 8
Default Copy A1 into C1 if B1 contains data??

I want to copy whatever is in A1 into C1 if B1 has data. If b1 is blank then
c1 should remain blank. The data in a1 or b1 could be either text or
numbers. As long as anything is in b1 then c1 should contain whatever is in
a1.