Multiple choice

[zqlcancer]

The logics I would apply for this tool are 

1.  if the tax code=A1 and country code=AA or is null, then return 1.
2. if the tax code=A2 and country code=AA or is null, then return 11.
3. Otherwise return 2

Looks like my formula are correct but I am not sure if this is the perfect way to do that. I am asking this due to in real practice I have many combinations and wonder if there is an easy way to get my result.

[FrederikE · Accepted solution]

Hey @zqlcancer,

You can certainly simplify it a bit. 

E.g. The ones where "1" is assigned you can do: 

IF [Tax Code]='A1' AND ([Country]='AA' OR [Country]=Null())

THEN 1

An other approach would be to create a lookup list, with many records this is for sure quicker. See the attached example.