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

Thanks for the code Donkey Ote,

I tested it over the weekend and forgot to post the thanks. However this morning there seems to be a discrepancy in the results its producing. Please see new attachment

ignore my last post. user error. i hadnt put my headers in prior to copying the formula.

Thanks again donkeyote