Excel If and else statement

Hi All,

Can somebody please help me with if and else in excel.

My codes seems correct when doing it separately, but when combining them - it does not work.

Codes are as follow:

=IFS(E7=Sheet2!$B$4,Sheet2!$C$4,IF(E7=Sheet2!B5,Sheet2!$C$5,"10"),IF(E7=Sheet2!$B$11,Sheet2!$C$11,IF(E7=Sheet2!B12,Sheet2!C12,Sheet2!C13)))

the last option still give me #value error.

have the sheet 2 that includes:

Merit Score
Low    2
Medium 5  
High  10   

Error   Score
Low   -2 
Medium -4
High -10