Hi everyone
I have an app that has question with three answers
Answer
A Answer
B Answer C
If the user selects
answer
A I want it to score 5 pts
B I want it to score 3 pts
C I want it to score 0 pts
And then total my points at the end of the survey
How would I go about doing this?
Thanks
You can use the switch() function to assign a value to each answer like this:
switch([AnswerColumn], “A”, 5, “B”, 3, “C”, 0, 0)
replacing [AnswerColumn] with whatever column you’re using to store the answer.
+Steve Coile Works Great thanks So Much
User | Count |
---|---|
41 | |
35 | |
27 | |
23 | |
16 |