I've got a quiz going out to lots of folk with fifty questions.
Now each user will receive a percentage score on what they got correct.
To do this I'm writing an enormous string of IF statements eg IF(a1=a2,1,0)+IF(b1=b2,1,0)...etc and then dividing by 50.
Can anyone tell me if there's a smarter way to do this?
(ie count two rows adding one where the two values match)