IF and AND - multiple conditions

[DickyMoo]

Hi all,

I would like to write the following custom column formula:

= if [Account Code] = "TIF" and [Journal Type] = {"DI","GJ",SAJ"}
then "Events"
else null

But I'm struggling to find the correct syntax for the highlighted section.

Does anyone know how I should be approaching this?

Thanks
Rich

 

[Bill Szysz]

= if [Account Code] = "TIF" and List.Contains( [COLOR=#ff0000]{"DI","GJ",SAJ"}[/COLOR], [COLOR=#ff0000][/COLOR][Journal Type] )[COLOR=#ff0000][/COLOR]
     then "Events"
  else null

Regards

 

[DickyMoo]

Brilliant, thank you very much

 

[Bill Szysz]

You are welcome