How to use combination from IF and OR functions in a SharePoint calculated column?

Hi,

I have a SharePoint 2013 list.
In it I have "1" column type Choice with values a1, a2, a3, b1, b2, b3, c1, c2, c3.
I would like to make calculated column "2" where, when I choose a1 or a2 or a3 the value is "a", if a choose b1or b2 od b3, the value is "b "and if I choose c1 or c2 or c3 the value is "c".
I tried with formula:
=IF(OR([1]="a1",[1]="a2",[1]="a3"),"a","b") , but it is functioning only for 2 values - combinations of "a" and "b", "a" and "c", or "b" and "c" , not for all of them.
Is there a way to do this?
Can you help me with the correct syntax?

Thanks in advance
Natasa SrbovskaAsked:
Who is Participating?
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.

 
Rgonzo1971Commented:
Hi,

pls try

=IF(OR([1]="a1",[1]="a2",[1]="a3"),"a",IF(OR([1]="b1",[1]="b2",[1]="b3"),"b","c"))

Open in new window

or
=IF(OR([1]="a1",[1]="a2",[1]="a3"),"a",IF(OR([1]="b1",[1]="b2",[1]="b3"),"b",IF(OR([1]="c1",[1]="c2",[1]="c3"),"c","")))

Open in new window

Regards
1

Experts Exchange Solution brought to you by ConnectWise

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
 
Rgonzo1971Commented:
or simply
=LEFT([1], 1)

Open in new window

0
 
Natasa SrbovskaAuthor Commented:
Thank you very much, that's it
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.