AND(
AND(
Country <> "United States"),
Country <> "USA"),
Country <> "US"),
Country <> ""),
"International",
IF(
CASE( State,
"AK","West",
"AL","Southeast",
"AR","Southeast",
"AZ","West",
"CA","West",
"CO","West",
"CT","East’",
"DC","East",
"DE","East",
"FL","Southeast ",
"GA","Southeast ",
"HI","West",
"IA","Central",
"ID","West",
"IL","Central",
"IN","Central",
"KS","Central",
"KY","Southeast ",
"LA","Southeast ",
"MA","East",
"MD","East",
"ME","East",
"MI","Central",
"MN","Central",
"MO","Southeast",
"MS","Southeast",
"MT","West",
"NC","Southeast",
"ND","Central",
"NE","Central",
"NH","East",
"NJ","East",
"NM","West",
"NV","West",
"NY","East",
"OH","Central",
"OK","Southeast",
"OR","West",
"RI","East",
"SC","Southeast",
"SD","Central",
"TN","Southeast",
"TX","Southeast",
"UT","West",
"VA","East",
"VT","East",
"WA","West",
"WI","Central",
"WV","East",
"WY","West",
"PA","East",null)
))
8 Antworten
I am still getting an error. I made the edits Jeff suggested, and it ist still giving me an error. This time the error is: Found IF.
IF
AND(
Country <> "United States"),
Country <> "USA"),
Country <> "US"),
Country <> ""),
"International",
CASE( State,
"AK","West",
"AL","Southeast",
"AR","Southeast",
"AZ","West",
"CA","West",
"CO","West",
"CT","East’",
"DC","East",
"DE","East",
"FL","Southeast ",
"GA","Southeast ",
"HI","West",
"IA","Central",
"ID","West",
"IL","Central",
"IN","Central",
"KS","Central",
"KY","Southeast ",
"LA","Southeast ",
"MA","East",
"MD","East",
"ME","East",
"MI","Central",
"MN","Central",
"MO","Southeast",
"MS","Southeast",
"MT","West",
"NC","Southeast",
"ND","Central",
"NE","Central",
"NH","East",
"NJ","East",
"NM","West",
"NV","West",
"NY","East",
"OH","Central",
"OK","Southeast",
"OR","West",
"RI","East",
"SC","Southeast",
"SD","Central",
"TN","Southeast",
"TX","Southeast",
"UT","West",
"VA","East",
"VT","East",
"WA","West",
"WI","Central",
"WV","East",
"WY","West",
"PA","East",)
)
