Formula for class scores

Occasional Visitor

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 only have a "/" if the work is completed or an "n" - I want to use these to help calculate an overall score for each student. In the first cell, I would like ten points awarded if a student completes it, and negative ten points if they don't. For the other two cells, I would like five points to be awarded for completion and zero if they are not completed. I want to have the sum of these scores in a fourth cell. Can anyone help with this? Thanks in advance

1 Reply

@MrGallant 

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.