IF Then - Mulitple Conditions

[LMaeExcel]

Hello! I am hoping for some help with an If Then formula or possibly another formula that will accomplish the below:

I'd like the formula to check for multiple conditions, such as:
If B2 = "MI" then say "MI2" in this cell, or if B2 = "NY" then say "NY2" in this (same) cell, or I B2 = "FL" then say "FL2" in this (same) cell... and so on

Help is appreciated!

 

[Roderick_E]

Maybe something like:

=IF(b2={"MI","NY","FL"},{"MI2","NY2","FL2"})

 

[LMaeExcel]

Thanks for your reply Roderick_E!!
I'm still experimenting, but I think I'm onto something. =if(A1="NY","NY2",if(A1="AZ","AZ2",if(A1="MI","MI2"," "))) Seems to be working so far, but I'll try yours out too and see if that also works.

 

[jimrward]

Are you always adding 2 to the end of 2 character strings

If so, try, =IF(LEN(A1)=2,A1&"2",A1)

 

[LMaeExcel]

jimrward, that did it! Thank you! The formulas above were working, but as I continued to include 50+ scenarios, it stopped working when it reached a certain length.
Simple and worked awesome!

 

[T. Valko]

Are you always adding 2 to the end of 2 character strings

If so, try, =IF(LEN(A1)=2,A1&"2",A1)

You don't need to use quotes around the number 2.

=IF(LEN(A1)=2,A1&2,A1)

The only time you'd need to quote numbers is if it's a string of numbers starting with a leading 0.

=IF(LEN(A1)=2,A1&"012",A1)