This content has been marked as final. Show 3 replies
I have a data table with addresses where I need to look for and abbreviate certain words, in various countries.
I have created an IF statement that works, but only for 1 country;
However, I have tried various ways of adding further IF statements to this for the other countries, but they seem to cancel each other out.
So basically I have 5 country codes (AT, BE, GB, NL, DE) each with it's own set of words that I would like to highlight when that particular country code is selected from the 'CountryFilter' field.
Is it possible to insert multiple if statements here, or is there a better way of going about this?
Any suggestions would be much appreciated.