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

E

ExcelQuestion

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?
 
V

vezerid

=(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
 
Top