Nested IF Formulas

kcaudill1989

I am trying to populate a cell based on the State that they had choice from a dropdown column on the same sheet/row. I am tried many variations of the below formula and it is not working.

Does anyone have any suggestions.

Brucey

This looks correct to me - there is a stray space after the second IF statement before the bracket. That might help

kcaudill1989

Thanks

I did try the CONTAINS formula and it worked with the exception of Arkansas/Kansas, etc.

I switched it to a HAS formula and it worked perfectly.

Thanks