Forum Discussion
Formula for class scores
Hi, I'm trying to produce a spreadsheet based on student completion of homework - I currently have 3 cells for the 3 different parts they need to complete. I've set it so that these cells can onl...
Let's say the / or n is in columns B to D, starting in row 2.
In E2:
=10*(B2="/")-10*(B2="n")+5*(C2="/")+5*(D2="/")
Fill down.