IF AND Contains Statement

[jenki07]

hello - 

I am trying to write a formula given the following: if column [A] contains 'bottle' and column [B] contains 'blister' then 1 else 0. 

[Felipe_Ribeir0]

Hi @jenki07 

Try like this:

if CONTAINS([ColumnA], 'bottle') and CONTAINS([columnB], 'blister') then 1 else 0 endif

[DataNath]

Hey @jenki07, the syntax here just needs cleaning up a little and you'll also need to add 'endif' to close out the statement:

if Contains([A], 'bottle') and Contains([B],'blister') then 1 else 0 endif

[DenisZ]

Try this in the formula tool

IF [A] = "bottle" AND [B] = "blister" THEN 1 ELSE 0 ENDIF

Should hopefully work. 

[KrishnaChithrathil]

@jenki07 

another way of doing the same.

I hope this is your real scenario.