Empty / blank formula

[Julien_Etoke]

Hello!

I'm making a table to generate contracts. Sometime there is 1 name on the contract, sometime 2.

List of my columns :
Name 1
Name 2
And (just a formula for write "and" in the column).

I'm trying to find the good way to write the formula of my and column :

CONCATENATE({And}, " ", {Name 2}) (it works fine)

IF({Name 2} = BLANK() => don't show "and" in this column.

Thanks for your reading!

Have a nice day.

[kuovonne · Accepted solution]

You want to put the word " and " between the two names, if there are two names?

If either name could be present, eg. {Name 2} without a {Name 1}.

CONCATENATE(
  {Name 1},
  IF( AND({Name 1}, {Name 2}), " and "),
  {Name 2}
)

If {Name 2} only appears if there is also a {Name 1}

CONCATENATE(
  {Name 1},
  IF( {Name 2}, " and " & {Name 2})
)

[Julien_Etoke]

Not really, I wants to show the word "and" in my formula only if the field "name 2" is not blank 🙂

[Julien_Etoke]

I know i'm close !

=IF(OR({Name 2}=BLANK(),CONCATENATE({Name 2},{And}),CONCATENATE({Name 2},", ",{And}))

Any idea @kuovonne ? 🙂

[kuovonne · Accepted solution]

> Not really, I wants to show the word "and" in my formula only if the field "name 2" is notblank 🙂

That's what my formulas do. Did you try them? If they do not give the results you want, could you send screen shots?

[Julien_Etoke]

Hello!

It works, I do not know how I managed but I did not get the right result by testing the first time!

Thanks a LOT 🙂