I can't reproduce that!

Please give the values of all cells involved and what result you get.

It may help to evaluate your formula step by step, using ToolsFormula AuditingEvaluate Formula (not too old versions of Excel)


--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"yovation" wrote in message ups.com...
| =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
|