How do I create a formula for a quiz in Excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to have a list of questions and when the answers are typed into
corresponding cells I want the following cell to say 'True' of "False'. How
do I create the forumla?
 
=(C2=__Correct Answer__) assuming the answer is in C2.

This formula will produce the Excel logical values TRUE/FALSE. In the
formula above, if __Correct Answer__ is expected to be text, enclose in
double quotes. If it is supposed to be a number then no quotes.

If you want to sum the TRUE answers, you might want to use
=COUNTIF(E:E, TRUE)
assuming that all formulas that return true/false are in column E:E.

HTH
Kostis Vezerides
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula results don't change when it's pasted/dragged into a new c 2
PowerPoint vba to insert name on Quiz Certificate in PowerPoint 0
Using the if function in a formula, 1
Making part of a formula a variable 1
Converting 0 values to Blanks 5
How to verify selected data from drop-down list? 1
Sumif based within non blank cells 3
Photos in cells? 11

Back
Top