Help with Primary field formula

[Troy_Gamble]

Hi there

I’m wanting to NOT show the “and” if the {Preferred - CB} is blank. Currently, it looks like this: Smith, Mark and Suzie

And here’s my current formula:
{Last Name} & " , " & {Preferred - B} & " and " &{Preferred - CB}

Any ideas? Thanks in advance!

[Elias_Gomez_Sai]

Check that first:

{Last Name} & " , " & {Preferred - B} & IF({Preferred - CB}, " and "&{Preferred - CB})

[Troy_Gamble]

This worked perfectly! Thank you Elias.