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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!