Quiz using the If formula

merryperson

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

Some videos you may like

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

StuLux

Well-known Member
Joined
Sep 14, 2005
Messages
642
Office Version
  1. 365
Platform
  1. Windows
Try the following:

Book1
ABC
1What is the sum of 3 + 4
2A5
3B6
4C7
5AnswerAIncorrect
Sheet1
Cell Formulas
RangeFormula
C5C5=IF(B5="","",(IF(B5="C","Correct","Incorrect")))
Cells with Data Validation
CellAllowCriteria
B5List=$A$2:$A$4
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
48,142
Office Version
  1. 365
Platform
  1. Windows
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

Well-known Member
Joined
Feb 3, 2010
Messages
9,691
Office Version
  1. 365
Platform
  1. Windows
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

New Member
Joined
Apr 6, 2020
Messages
5
Office Version
  1. 2007
Platform
  1. Windows

ADVERTISEMENT

Quiz using the If formula.png
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
48,142
Office Version
  1. 365
Platform
  1. Windows
Glad we could help & thanks for the feedback
 

Watch MrExcel Video

Forum statistics

Threads
1,114,068
Messages
5,545,800
Members
410,708
Latest member
SanTrapGamer
Top