Combining IF and OR
What I'm trying to say is:
If A1 Rank = 1, 2 or 3 then Awareness
If D Rank = 1, 2 or 3 then Desire
If K Rank = 1, 2 or 3 then Knowledge
If A2 Rank = 1, 2 or 3 then Ability
If R Rank = 1, 2 or 3 then Reinforcement
If none is true then NONE
=IF(OR([A1 Rank]@row = “1”, [A1 Rank]@row = “2”, [A1 Rank]@row = “3”), “Awareness”, IF(OR([D Rank]@row = “1”, [D Rank]@row = “2”, [D Rank]@row = “3”), Desire, IF(OR([K Rank]@row = “1), [K Rank]@row = “2”, [K Rank]@row = “3”), Knowledge”, IF(OR([A2 Rank]@row = “1”, [A2 Rank]@row = “2”, [A2 Rank]@row = “3”), “Ability”, IF (OR([R Rank]@row = “1”, [R Rank]@row = “2”, [R Rank]@row = “3”), Reinforcement, “NONE”)))))
I keep getting an #unparseable error
Answers

I seem missing quotation marks, might be more this is just what I see
Help Article Resources
Categories
Check out the Formula Handbook template!