You need to sign in to do that
Don't have an account?
Terry_0101
How to use OR in this formula?
How to have this read "if the state contains certain states OR if it contains Canada, then tag it as US - West"?
IF(ISBLANK( State ), "",
IF(ISBLANK( Country ), "",
IF(CONTAINS("Alaska:Washington:California:Oregon:Hawaii:Nevada", State ), "US - WEST",
IF(CONTAINS("Canada", Country ), "US - WEST", ""))))
IF(ISBLANK( State ), "",
IF(ISBLANK( Country ), "",
IF(CONTAINS("Alaska:Washington:California:Oregon:Hawaii:Nevada", State ), "US - WEST",
IF(CONTAINS("Canada", Country ), "US - WEST", ""))))
You could do this (tested to work):
IF(AND(ISBLANK(ShippingState),ISBLANK(ShippingCountry)), "",
IF(CONTAINS("Alaska:Washington:California:Oregon:Hawaii:Nevada", ShippingState ), "US - WEST",
IF(CONTAINS("Canada", ShippingCountry ), "US - WEST", "")))
All Answers
You could do this (tested to work):
IF(AND(ISBLANK(ShippingState),ISBLANK(ShippingCountry)), "",
IF(CONTAINS("Alaska:Washington:California:Oregon:Hawaii:Nevada", ShippingState ), "US - WEST",
IF(CONTAINS("Canada", ShippingCountry ), "US - WEST", "")))
Try this:
IF(UPPER(ShippingCountry) = "Canada", "US - WEST",
CASE( UPPER(ShippingState),
"ALASKA", "US - WEST",
"CALIFORNIA", "US - WEST",
"OREGON", "US - WEST",
"WASHINGTON", "US - WEST",
"HAWAII", "US - WEST",
"NEVADA", "US - WEST",
""))