excel multiple choice toggles

[THIRDCOAST]

I am trying to build a test that has multiple choice and true/false choice
toggles. I am trying to make the toggles score the test for me. How do I make
the "toggled" answer send a value to another cell for me to total and provide
a test result?

Thanks

 

[JP]

If the answers were in column B, and each "True" answer was worth 5
points, you could use

=COUNTIF(B1:B100,"=True")*5

to score the number of true answers.

Unfortunately you haven't provided enough information about the
problem. If you provide more information or an example, someone could
assist you further.


HTH,
JP

 

[THIRDCOAST]

An example would;
(Column A) Question 1: Today is January (column B) the 5th, (column C) the
6th, (column D) the 7th.
(Column A) Question 2: Tomorrow is January (column B) the 5th, (column C)
the 6th, (column D) the 7th.

I am trying to assign a point value for each answer (B) is the answer for
Q#1 and (C) the answer for Q#2. But I want to give 3 points for the correct
answer and various points for the wrong answer...ie...2 pts or 1 pts. for the
others. They have to be assigned differing columns because students would
just pick answer "B" like we did in college...lol. Thanks for your assistance.

 

[JP]

You would need some kind of answer key to show which is the correct
answer for each question. I found a link that might be able to assist.

http://www.mrexcel.com/archive2/67500/78201.htm

If that isn't enough, I recommend reposting so that more people will
view your question.

HTH,
JP