Thread: Why doesn't this work?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
yovation yovation is offline
external usenet poster
  
Posts: 18
Default Why doesn't this work?
=CONCATENATE(IF(B30,B3,""),IF(C30,C3&", ",""),IF(D30,D3&",
",""),IF(E30,E3&", ",""))

When any of the logicals are false, the formula still displays the ,

Assistance please?

Thank you

Reply With QuoteReply With Quote