troubleshooting Question

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

Avatar of Natasa Srbovska
Natasa Srbovska asked on
Microsoft SharePoint
3 Comments1 Solution135 ViewsLast Modified:
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
Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros