I need to search a few different variants of this country in this formula, how would I add multiple options in place of ' 'UNited Kingdom' say 'United Kingdom, GB, Great Britan' ect
IF(BillingCountry = 'United Kingdom', TRUE, FALSE)
Thanks!
Shay
4 answers
Eric Praud (Activ8 Solar Energies) Forum Ambassador
Hi Shay, First I woudl use the LOWER or UPPER function so you don't have to worry about case-sensitivity. Then use a CASE function like so:
IF(
CASE(LOWER(BillingCountry),'united kingdom',1,'uk',1,'u.k.',1,'u.k',1,'gb',1,'g.b',1,'great britain',1,'england',1,'scotland',1,'wales',1,'northern ireland',1,0)=1, TRUE, FALSE)
Now, this seems to be a checkbox formula, if so, no need for True/False, simply going with this would work:
CASE(LOWER(BillingCountry),'united kingdom',1,'uk',1,'u.k.',1,'u.k',1,'gb',1,'g.b',1,'great britain',1,'england',1,'scotland',1,'wales',1,'northern ireland',1,0)=1