I have a formula that checks to see if the Account is in a European Country - It marks it as "YES" or "BLANK"
However, if the Country is BLANK on the record, they are marking as "YES". Am I missing something in my formula?
Formula: IF(CONTAINS("Albania: Andorra: Armenia: Austria: Azerbaijan: Belarus: Belgium: Bosnia and Herzegovina: Bulgaria: Croatia: Cyprus: Czechia: Denmark: Estonia: Finland: France: Georgia: Germany: Greece: Hungary: Iceland: Ireland: Italy: Kazakhstan: Kosovo: Latvia: Liechtenstein: Lithuania: Luxembourg: Malta: Moldova: Monaco: Montenegro: Netherlands: North Macedonia: Norway: Poland: Portugal: Romania: Russia: San Marino: Serbia: Slovakia: Slovenia: Spain: Sweden: Switzerland: Turkey: Ukraine: United Kingdom", BillingCountry), "Yes", "")
Eric Praud (Activ8 Solar Energies) 
Forum Ambassador
Hi Christopher,
CONTAINS returns true on blank fields.
Simply go with:
IF(ISBLANK(BillingCountry),NULL,
IF(CONTAINS("Albania: Andorra: Armenia: Austria: Azerbaijan: Belarus: Belgium: Bosnia and Herzegovina: Bulgaria: Croatia: Cyprus: Czechia: Denmark: Estonia: Finland: France: Georgia: Germany: Greece: Hungary: Iceland: Ireland: Italy: Kazakhstan: Kosovo: Latvia: Liechtenstein: Lithuania: Luxembourg: Malta: Moldova: Monaco: Montenegro: Netherlands: North Macedonia: Norway: Poland: Portugal: Romania: Russia: San Marino: Serbia: Slovakia: Slovenia: Spain: Sweden: Switzerland: Turkey: Ukraine: United Kingdom", BillingCountry),
"Yes", NULL))
