merryperson
Board Regular
- Joined
- Apr 27, 2005
- Messages
- 72
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?
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?