Formula not working for creating a score in a survey

Dramos

=IF(OR([Is the agency's experience with local, state or fe]@row = "≤ 1 year", 1), IF(OR([Is the agency's experience with local, state or fe]@row = "≥ 5 years", 2), ([is the agency's experience with local, state or fe]@row = "> 5 years",3)))

I'm willing to change the formula completely if there is a better form or function to accomplish getting the score.

Background: I have a survey and there is a drop down where the survey taker can choose three options and get a score based on which one they select.

👀

Nic Larsen

Try: =IF([Is the agency's experience with local, state or fe]@row = "≤ 1 year", 1, IF([Is the agency's experience with local, state or fe]@row = "≥ 5 years", 2, 3

Dramos

This really helped!

THANK YOU!!!!

Here's the final working solution:

=IF([Is the agency's experience with local, state or fe]@row = "≤ 1 year", 1, IF([Is the agency's experience with local, state or fe]@row = "≥ 5 years", 2, IF([Is the agency's experience with local, state or fe]@row = "< 5 years", 3)))