Quiz using the If formula

[merryperson]

I wanted to start a quiz using excel and having a question with the choice of 3 answers.

So I have a question what is the sum of 3 + 4
The answers are
A =5
B= 6
C=7
If they put in the answer A or B they get a message saying wrong answer Try again.
if they choose correctly C they get a message Correct.
I used the If formula IF (A1= “A” “Correct’, “Try again”)and this worked but only with two answers but i want three choices to choose from
Any ideas?

 

[StuLux]

Try the following:

Book1
	A	B	C
1	What is the sum of 3 + 4
2	A	5
3	B	6
4	C	7
5	Answer	A	Incorrect
Sheet1

Cell Formulas
Range	Formula
C5	C5	=IF(B5="","",(IF(B5="C","Correct","Incorrect")))

Cells with Data Validation
Cell	Allow	Criteria
B5	List	=$A$2:$A$4

 

[Fluff]

this worked but only with two answers but i want three choices to choose from

Your formula will work with any number of answers, as long as there is only one correct answer.

 

[JackDanIce]

To test @Fluff 's remark, you can create a drop-down list in A1 with values "A", "B", "C", "D", "E" and in B1 your formula =IF(A1="A","Correct","Try again")
Then use the drop down to select each choice and check result in B1

 

[Ghozi alkatiri]

 

[merryperson]

Brilliant both work as needed much appreciated for all your wisdom

 

[Fluff]

Glad we could help & thanks for the feedback