logical function

I have tried building a logical function that can help me calculate the exact values in the Score column. This can help me calculate for large data. values under the score section are the criteri...