Forms????

S

Son

Help. I am trying to create a multiple choice test. I have created
drop down list and linked the answers to a cell. That linked cell give
me a number from 1 to 4 (the No of choices).

I would like to know how I can then link this cell so that if it is th
right answer I get a unique No.

Or if any one else has a better solution to this problem-pleas
help!!!!
 
C

Charlie

If the linked cell containing the answer is A1 and the
correct answer is 4 and the unique value is 10, then in B1
enter =If(A1=4,10,0)

Hope this helps

Charlie O'Neill
 
Top