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


On Jan 6, 8:02*pm, THIRDCOAST
wrote:
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" wrote:
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

On Jan 6, 4:56 pm, THIRDCOAST
wrote:
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- Hide quoted text -

- Show quoted text -