Convert IF statement for TSQL

Transact-SQL
1

Hello All,

Please I am looking at converting this IF statement to TSQL to create a new column called Hardness:

=IF(RIGHT(name,2)="80",IF(PenetrationRate<49.5,"H",IF(PenetrationRate>82.5,"S","M")),
IF(RIGHT(name,2)="84",IF(PenetrationRate<49.5,"H",IF(PenetrationRate>82.5,"S","M")),
IF(RIGHT(name,2)="87",IF(PenetrationRate<49.5,"H",IF(PenetrationRate>82.5,"S","M")),
IF(RIGHT(name,2)="81",IF(PenetrationRate<64.5,"H",IF(PenetrationRate>107.5,"S","M")),
IF(RIGHT(name,2)="85",IF(PenetrationRate<64.5,"H",IF(PenetrationRate>107.5,"S","M")),
IF(RIGHT(name,2)="86",IF(PenetrationRate<64.5,"H",IF(PenetrationRate>107.5,"S","M"))))))))

I have 2 columns name and PenetrationRate. For example, I want to say, if the last 2 digits of name is 80, and PenetrationRate is less than 49.5, put 'H' in the new Hardness column, if it is greater than 82.5, put 'S' else put 'M' in the hardness column.

Thank you in advance

2 
case
   when (right(name,2) in ('80','84','87') and penetrationrate<49.5)
     or (right(name,2) in ('81','85','86') and penetrationrate<64.5)
   then 'H'
   when (right(name,2) in ('80','84','87') and penetrationrate>82.5)
     or (right(name,2) in ('81','85','86') and penetrationrate>107.5)
   then 'S'
   when right(name,2) in ('80','81','84','85','86','87')
   then 'M'
   else '' /* if anything else */
end
3

Thank you @bitsmed