Skip to main content
Hi! 

 

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 件の回答
  1. Eric Praud (Activ8 Solar Energies) Forum Ambassador
    2021年1月6日 12:03
    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