1

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])))
Improve this question

1 Answer 1

Reset to default
1 
=IF(AND([Master File]="[Choose Masterfile]",[Master File 2]="[Choose Masterfile]"),"NONE LISTED",IF([Master File]="[Choose Masterfile]",[Master File 2],IF([Master File 2]="[Choose Masterfile]",[Master File],CONCATENATE([Master File], [Master File 2]))))

Something like this should work though you need to check the values are correct.

Improve this answer
1
  • I used this code under. It still does do the concatenation. The good news is, it doesn't throw any errors: 'code=IF(AND([Master File]="[Choose Masterfile]",[Master File 2]="[Choose Masterfile]"),"NONE LISTED",IF([Master File]<>"[Choose Masterfile]",[Master File],IF([Master File 2]<>"[Choose Masterfile]",CONCATENATE([Master File],[Master File 2]))))'
    – user12938
    Jul 24, 2013 at 18:01

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.