I am having trouble nesting concatenate formula with if statement - syntax error. I am trying to create a calculated column. This column will list "master file" string if exist. If two master files exists (two separate columns), then this column should list both. Example - master file 1 or None if none exist. Master file 1, masterfile 2 if both exist. Below is my code so far. Any help would be appreciated and thank you in advance.
=IF([Master File]="[Choose Masterfile]","NONE LISTED",[Master File],IF(AND[Master File 2] <> '[Choose Masterfile]",CONCATENATE([Master File] + [Master File 2])))