Link to home
Get AccessLog in
Avatar of Natasa Srbovska
Natasa Srbovska

asked on

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
ASKER CERTIFIED SOLUTION
Avatar of Rgonzo1971
Rgonzo1971

Link to home
membership
This content is only available to members.
To access this content, you must be a member of Experts Exchange.
Get Access
Avatar of Rgonzo1971
Rgonzo1971

or simply
=LEFT([1], 1)

Open in new window

Avatar of Natasa Srbovska

ASKER

Thank you very much, that's it