Excel, If / Then or is there a better way?
Closed
WMCAROLI
Posts
1
Registration date
Friday March 15, 2013
Status
Member
Last seen
March 15, 2013

Mar 15, 2013 at 04:01 PM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022  Mar 16, 2013 at 11:46 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022  Mar 16, 2013 at 11:46 AM
Related:
 Excel, If / Then or is there a better way?
 Excel date format dd.mm.yyyy  Guide
 Excel if color is red then  Guide
 Transfer data from one excel worksheet to another automatically  Guide
 Excel conditional formatting if another cell contains specific text ✓  Excel Forum
 Excel if cell is date ✓  Office Software Forum
2 replies
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
767
Mar 16, 2013 at 11:46 AM
Mar 16, 2013 at 11:46 AM
Zohaib has provided a solution. Since you asked "if there is a better way", i thought i would throw in my two cents too
1. Column A, Questions
2. Column B, Correct Answer for questions
3. Column C, Number of correct answers for a question by class. Kind of summary for a question
4. Column D:AB : just answer of student where each column is a student
5. Summarize results at bottom
1. Column A, Questions
2. Column B, Correct Answer for questions
3. Column C, Number of correct answers for a question by class. Kind of summary for a question
4. Column D:AB : just answer of student where each column is a student
5. Summarize results at bottom
Zohaib R
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
67
Mar 15, 2013 at 05:57 PM
Mar 15, 2013 at 05:57 PM
Hi WMCAROLI,
I have used the following formula to evaluate the result for each question:
=IF(B2="A",1,0)
The answer is in Cell B2 which has a drop down that allows you to select from four options "A", "B", "C" and "D". The correct answer for this above question is "A", if "A" is selected from the drop down the result will be 1 else 0. This formula can be used for different answers also using the same logic. Because the result is either 1 or 0, it helps in getting aggregate of all the 40 questions.
I have prepared a sample sheet for two students you can extend it for the next 25. You can download the sample sheet from the below mentioned link:
http://speedy.sh/RU6QU/QuestionSheetfor25Studentand40Question.xlsx
Do reply with results.
I have used the following formula to evaluate the result for each question:
=IF(B2="A",1,0)
The answer is in Cell B2 which has a drop down that allows you to select from four options "A", "B", "C" and "D". The correct answer for this above question is "A", if "A" is selected from the drop down the result will be 1 else 0. This formula can be used for different answers also using the same logic. Because the result is either 1 or 0, it helps in getting aggregate of all the 40 questions.
I have prepared a sample sheet for two students you can extend it for the next 25. You can download the sample sheet from the below mentioned link:
http://speedy.sh/RU6QU/QuestionSheetfor25Studentand40Question.xlsx
Do reply with results.