Calculate % based on 2 Requirements

Afternoon All,

I have the below attached spread sheet. What i need this time is to calculate the % of SLA. To do this would need to follow the following

IF H = P1 THEN SLA = 4
IF H = P2 THEN SLA = 8
IF H = P3 THEN SLA = 30
IF H = P4 THEN SLA = 50

To calculate the % you would then need to look at open hours "K"

Example:

H2 = P3
K2 = 0.13
L2 = 0.004444 (K2 / 30)

Any help as always would be appreciated.

LinkOps