How to combine 3 fields with IF statements?

[Markus_Wernig]

I am sure this is easy, but I can’t figure it out on my own. I’d very much appreciate if some could point me in the right direction.

I have 3 fields: {WRITER 1} {WRITER 2} {WRITER 3}
I am looking for a formula to combine them into one field.
The names should be separated by commas in the new combined field.
I can do the above easily, BUT:
The fields are not always filled. Sometimes only one of them is filled, sometimes all 3.
So I need IF statments in combination with =BLANK()
I can do it for WRITER 1 and 2, but I can’t get the 3rd one in…

Thank you in advance! I am lost.

[Markus_Wernig]

Hi Kris,

it worked! I took your advice and switched to a plain text editor. It must have been the quotes getting changed in the process.

Thanks again. I really appreciate your help.