# Excel, If / Then or is there a better way?

[Closed]
Report

WMCAROLI

rizvisa1

- Posts
- 1
- Registration date
- Friday March 15, 2013
- Status
- Member
- Last seen
- March 15, 2013

rizvisa1

- Posts
- 4476
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- August 2, 2020

Related:

- Excel, If / Then or is there a better way?
- Transfer data from one excel worksheet to another automatically - How-To - Excel
- How to change date format in excel to dd/mm/yyyy - How-To - Excel
- Excel @ in formula ✓ - Forum - Excel
- How to change author name in excel - How-To - Excel
- Compare two worksheets and paste differences to another sheet - excel vba free download ✓ - Forum - Excel

## 2 replies

rizvisa1

- Posts
- 4476
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- August 2, 2020

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

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.