Gio
June 13, 2020, 2:12pm
#1
Hello airtablers,
I have a field {RESPONSE} with 5 possible choices A,B,C,D,E
I need to be able to give a score based on each response.
So if response is A OR B score is 4
if response is C OR D score is 1
if response is E score is 3
This would be easy to solve with a switch function but the cell with responses returns all the responses concatenated in a single array (A;B;C;D;E).
Is there a way to score the responses?
Thanks a lot
You can use the SEARCH function within a nested IF statement like this:
IF(
SEARCH("A",Response),4,
IF(
SEARCH("B",Response),4,
IF(
SEARCH("C",Response),1,
IF(
SEARCH("D",Response),1,
IF(
SEARCH("E",Response),3
)))))
Hope this helps! If this answers your question, could you please mark this comment as the solution to your question? This will help other people who have a similar question.
system
closed
June 26, 2020, 3:11pm
#3
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.