Mutliple IF conditions to calculate SLA

[vtamilamudhan]

Criteria to breach sla in days
CRITICAL 1
HIGH 1
AVERAGE 2
LOW 3

Severity Days Old SLA ACHIEVED
CRITICAL 1
HIGH 4
AVERAGE 2
LOW 1
CRITICAL 9
HIGH 10
AVERAGE 13
LOW 14

Please help me to create if condition formula to calculate sla breach by depending on Days OLD values with the actual criteria

[shirleyxls]

Try this in G2 and copy down

=IF(F2>VLOOKUP(E2,$A$2:$B$5,2,FALSE),"Breach","No breach")