Use a set of “if statements” to calculate the percentage of possible points earned for multiple choice (MC) items and open response (OR) items for each student. Record your calculations in columns D and E.
Any clue on how to write the If statement
enter image description here
=IF(H8:AF8=MC)then ???
New contributor
Dildo Shwaggins is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.