Excel help with what if [Solved/Closed]

Report
-
 Tammy -
Hello,


I have all the states in column A and I need to result to display in column B. I need Column B to show "Yes" if column A has: MT, ID, WY, UT, CO, AZ, or MD and "No" if it does not contain any of the above listed states.

For example: If A2 is MT then I want it to display Yes and if not, then I want it to show No in Cell B2. I need the formula so that I can copy it down in column B.

Please help.

1 reply

Nevermind, I figured it out. Thanks!

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!