Hi
I am trying to a test sheet for school kids in XP 2003
I have 20 questions They choose one of three possible answers from a drop
down list (did that). Now I want to compare their choice with the correct
answer in the adjacent cell, which will be a hidden column. If the word
matches correctly message says correct if not incorrect. an If statement
should do it I think .
I then want them to click a button to unhide the column with the correct
answers and reveal their score out of 20. I am not sure what formula to use
for the last calculation or the exact IF formula.
Can anyone help or am I going about this the wrong way?
Thanks

I have posted a simple example for you at http://cjoint.com/?cisU5tNmcF

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"kim" wrote in message
...
Hi
I am trying to a test sheet for school kids in XP 2003
I have 20 questions They choose one of three possible answers from a drop
down list (did that). Now I want to compare their choice with the correct
answer in the adjacent cell, which will be a hidden column. If the word
matches correctly message says correct if not incorrect. an If statement
should do it I think .
I then want them to click a button to unhide the column with the correct
answers and reveal their score out of 20. I am not sure what formula to
use
for the last calculation or the exact IF formula.
Can anyone help or am I going about this the wrong way?
Thanks