if formula with multiple choices

[qv2]

in a testing setting, i have several 'wrong' answer question numbers that refer to a particular subject....ie if you miss questions 1,3,5,7,9 you need to work on pronouns.

how can i get an excel 'if' function to return 1 value for several selections? i envision the following:

if(a1= 1 or 2 or 3 or 4 or 5, "pronoun","")

but of course that doesn't work, nor does 1,2,3,4

any help?

 

[qv2]

mrkowz...if i told you that, you'd have my job!

actually, thanks for asking. here's the deal: i work for 3 teachers who give standardized testing in reading, math and language skills, all multiple choice. when the answer is wrong, it corresponds to a portion of the subject that needs to be remediated, ie: nouns, pronouns, division, subtraction, commas, structure etc. there are 50 reading questions, 75 math and 55 language. right now we use a paper grid and circle the wrong answer ... which means looking through all the numbers on the analyzing sheet to find the wrong answer in the subject. i thought if there was a way to let the teachers simply input the wrong answer directly from the testing sheet in a1,a2,a2 etc and have the subject come up in another row (f1,f2 etc) then quickly sort etc to give a printout...well it would be tidier and easier. any additional thoughts?