Formula to return the relevant multiplier value for fines

Morning all,

I have a schedule of fines and in some instances a multiplier effect is activated based on two criteria (no of consecutive failures & no of failures in a rolling 12 month period). I'd like a formula that returns the relevant multiplier effect (which is always the higher value) if either of these criteria is applicable.

Example attached.

Thanks in advance,

Snook