Struggling with Multiple Choice Formula

[brenda1996]

Hello all,

Looking for help in creating a formula to give me a correct or incorrect result for multiple choice answers.

Have tried IF AND and IF THEN ELSE to no avail and would like to learn more about nested formulas for which I think I need.

So say I have a multiple choice question that has 4 possible answers. 2 are Correct and 2 are Incorrect.

Now in cells A4, A5, A6 and A7, are the possible answers, I have a formula set up to tell me if what is chosen for each possibility is Correct or Incorrect in Cells E4-E7.

I am looking to combine these so in Cell B3, next to where the question is, I can get a result if the answers are correct.

If two are chosen and one is Correct and the other is Incorrect I would like to see the result in Cell B3 saying Incorrect.

If two are correct Cell B3 would say Correct.

All this is so I can work the numbers into a grade to check myself for a practice test of 128 questions.

I can't do it with 128 Questions, some of which have 4 possible answers. If there were only 2 answers it would be simple.

Thanks in advance for any help provided, it is sincerely appreciated

Brenda

 

[bebo021999]

Fast answers need visual help. Try to attach screenshot/mini sheet via XL2BB

XL2BB - Excel Range to BBCode

Excel 'mini-sheet' in messages - XL2BB Although experts prefer to read your description and question instead of working in your actual file to solve your problem, there are times that it is difficult to explain an issue without providing actual...

www.mrexcel.com