MCQ form
I created an MCQ form that I need to evaluate. for example: 1 question, if the correct is answer is C, it can give one mark or zero mark. like this way created 5 questions, 6th column is the result. it needs to sum up the answer. Please help me.
Best Answers
-
In this case you would change it to:
=IF([1.Question]@row = "C",1,0)
The [ ] brackets go around your column name that's being referenced.
-
If you had a column for each (1Q, 2Q, etc.) arranged in the way you've started, then you would use either of:
=1Q@row + 2Q@row + 3Q@row +4Q@row +5Q@row
=SUM([1Q]@row, [2Q]@row, [3Q]@row, [4Q]@row, [5Q]@row)
If you want to skip this, then this should work:
=IF([1.Question]@row = "C", 1, 0) + IF([2.Question]@row = "B", 1, 0) + IF([3.Question]@row = "A", 1, 0) + IF([4.Question]@row = "B", 1, 0) + IF([5.Question]@row = "B", 1, 0)
Answers
-
Hi @kumars23,
A couple of options for you:
You can add additional columns (to the sheet, but not the form) with an IF statement for each to show whether that person has gained a mark or not from that question. Using your example:
=IF([Question 1 Answer]@row = "C", 1,0)
This would give 1 mark for the correct answer of C and 0 for any other answer.
You can them sum these columns (by row).
Alternatively you can jump straight the total in a single column:
=(IF([Q1 Answer]@row = "C", 1, 0)) + IF([Q2 Answer]@row = "A", 1, 0) + .....
Hope this helps, but if you've any problems/questions then let us know. 🙂
-
Hi Nick Korna,
Thank you for your quick reply. I attached the problem. what I have to enter in the bracket. I mean column name ? Please help.
-
In this case you would change it to:
=IF([1.Question]@row = "C",1,0)
The [ ] brackets go around your column name that's being referenced.
-
It works for single-column formula. for each questions whether I need to create a single column? how can sum for all the 5 requestions? please help.
-
If you had a column for each (1Q, 2Q, etc.) arranged in the way you've started, then you would use either of:
=1Q@row + 2Q@row + 3Q@row +4Q@row +5Q@row
=SUM([1Q]@row, [2Q]@row, [3Q]@row, [4Q]@row, [5Q]@row)
If you want to skip this, then this should work:
=IF([1.Question]@row = "C", 1, 0) + IF([2.Question]@row = "B", 1, 0) + IF([3.Question]@row = "A", 1, 0) + IF([4.Question]@row = "B", 1, 0) + IF([5.Question]@row = "B", 1, 0)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 489 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!