April 15, 2020
I'm making a class quiz with 40 multiple-choice items. The value of each question is one point. In Excel, I need a formula to add up each 3 wrong answers and reduce one extra point from the total. For example, if the test taker has answered 37/40 questions correct, he should receive a score of 36. In this way he has lost one extra score for his wrong responses. I wonder if you could kindly help me out.