I have a long expression that works as intended, but I believe there is a more optimized way to write this. Any suggestions?
if([county_name] = 'APACHE', 'North',
if([county_name] = 'COCONINO', 'North',
if([county_name] = 'GILA', 'North',
if([county_name] = 'MOHAVE', 'North',
if([county_name] = 'NAVAJO', 'North',
if([county_name] = 'YAVAPAI', 'North',
if([county_name] = 'COCHISE', 'South',
if([county_name] = 'GRAHAM', 'South',
if([county_name] = 'GREENLEE', 'South',
if([county_name] = 'LA PAZ', 'South',
if([county_name] = 'PINAL', 'South',
if([county_name] = 'SANTA CRUZ', 'South',
if([county_name] = 'YUMA', 'South',
if([county_name] = 'MARICOPA', 'MARICOPA',
if([county_name] = 'PIMA', 'PIMA',
'REF')))))))))))))))
