This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Any way to rewrite this formula? Instead of looking at State for “BC”, using {City}
SWITCH(
{State},
“CT”, “New England”,
“ME”, “New England”,
“MA”, “New England”,
“NH”, “New England”,
“RI”, “New England”,
“VT”, “New England”,
“NJ”, “Mid-Atla...