You need to sign in to do that
Don't have an account?
Terry_0101
Formula not showing Netherlands value
This formula works for the USA states. But for Netherlands, it shows up as null.
IF(OR(ISBLANK(State),ISBLANK(Country)), "",
IF(CONTAINS("Alaska:Washington:California:Oregon:Hawaii:Nevada", State ), "US - WEST",
IF(CONTAINS("Netherlands:Norway", Country ),
"EUR",
"")))
The IF(OR( should look at IF statement as separate?
IF(OR(ISBLANK(State),ISBLANK(Country)), "",
IF(CONTAINS("Alaska:Washington:California:Oregon:Hawaii:Nevada", State ), "US - WEST",
IF(CONTAINS("Netherlands:Norway", Country ),
"EUR",
"")))
The IF(OR( should look at IF statement as separate?
Note that the CONTAINS formula is case sensitive, so you'll get different results for "NETHERLANDS" versus "Netherlands". For instance, if it's an issue of case sensitivity, you could do the following:
I tired the LOWER and not working.
Potential Problems:
IF(OR(ISBLANK(State),ISBLANK(Country)), "",
IF(CONTAINS("Alaska:Washington:California:Oregon:Hawaii:Nevada", State ), "US - WEST",
IF(CONTAINS("Netherlands:Norway", Country ),
"EUR",
"")))
State=Alaska, Country=' ' returns null
State=' ', Country=Netherlands returns null
State=Alaska, Country=Unites States returns US-West
State=Alaska, Country=Netherlands returns US-West
If you remove the OR statement the same scenarios will return the following:
State=Alaska, Country=' ' returns US-West
State=' ', Country=Netherlands returns EUR
State=Alaska, Country=Unites States returns US-West
State=Alaska, Country=Netherlands returns US-West
Let me know if these scenarios don't match your requirements, or if there's something missing.
I see, so there is no way to get Netherlands to only show EUR? And skip US West?