# Ifstatement

Hello!

column A has  a list of codes that can start with either "1", "2", "4', and "6". Column B needs to have a function that says if A1 starts with 1 then "A", if A1 starts with "2" then "B", if A1 starts with "4" then "C" and if A1 starts with "6" then "D"

Example:  A1= 201905555  - B1 should say "B"
A2=401303245 - B2 should say "C"
A3=600637985 - B3 should say "D"

thanks!
###### Who is Participating?

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

DirectorCommented:
If you intend this to get more complex then I would use VLookup with a hidden lookup table.  But assuming the list is not going to get any longer I would use the following formula in B1:
``````=IF(LEFT(A1,1)="1","A",IF(LEFT(A1,1)="2","B",IF(LEFT(A1,1)="4","C",IF(LEFT(A1,1)="6","D",""))))
``````
Commented:
You could make some nested if statements, but shorter like this, using the character codes, A=65, B=66 etc.
=CHAR(INT(LEFT(A1,1)/2)+65)
Commented:
Try this

=IF(LEFT(A1,1) = "2", "B", IF(LEFT(A1,1)= "4", "C", IF(LEFT(A1,1)="6", "D", "")))

then drag down the formula or try a Vlookup but this is smipler.
"Batchelor", Developer and EE Topic AdvisorCommented:
You could also use
``````=CHOICE(LEFT(A1,1), "A", "B",,"C",,"D")
``````
Commented:
or a lookup
=LOOKUP(--LEFT(A1),{1;2;4;6},{"A";"B";"C";"D"})

Experts Exchange Solution brought to you by