IF and AND - multiple conditions

DickyMoo

New member
Joined
Mar 7, 2016
Messages
27
Reaction score
0
Points
0
Location
London
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
 
Code:
= 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
 
Back
Top