Thread: If problem
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
sedonovan
 
Posts: n/a
Default If problem

Can you tell me what's wrong with this formula please

=if(sheet1!A2<"",sheet1!a2,"")

that is (being in sheet2)
if there's a value in A2 on sheet1
copy it/reference it on sheet2
if not, leave blank.

Many thanks,
Suzanne